Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

SharePoint Custom List, 3 fields to get one

I have three fields in my sharepoint list

field_est
field
field_actual

if field <> "" then field_actual = field
else
field_actual = field_est

How can this be done with a calculated field?
0
Matt Pinkston
Asked:
Matt Pinkston
1 Solution
 
manuj_nagpalCommented:
This can be done via below formula :
=IF(field<>"",field,field_est)

More Info : http://msdn.microsoft.com/en-us/library/bb862071.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now