Solved

SharePoint Custom List, 3 fields to get one

Posted on 2011-03-25
1
292 Views
Last Modified: 2012-05-11
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
Comment
Question by:Matt Pinkston
1 Comment
 
LVL 1

Accepted Solution

by:
manuj_nagpal earned 500 total points
ID: 35215207
This can be done via below formula :
=IF(field<>"",field,field_est)

More Info : http://msdn.microsoft.com/en-us/library/bb862071.aspx
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question