Solved

Nested Sharepoint Statement

Posted on 2016-08-19
8
19 Views
Last Modified: 2016-09-11
I have two date columns in a sharepoint list.  I need to create a nested formula that will mark either -
"Open", Pending Open" or "Closed"  (see attached file)

So I have three different scenarios to add to the formula.  I am fine creating a formula for two different but not three.

Thanks for your help!
0
Comment
Question by:vpopper
  • 4
  • 3
8 Comments
 
LVL 8

Expert Comment

by:Tim Edwards
ID: 41762688
Can you please add the attachment
0
 

Author Comment

by:vpopper
ID: 41762698
0
 
LVL 26

Expert Comment

by:Shaun Kline
ID: 41762833
Try using a nested IF statement:
=IF([@[Date Completed]]<>"", "Closed", IF([@[Effective Date]]<>"", "Pending Open", "Open"))
0
 

Author Comment

by:vpopper
ID: 41765381
Getting error...is there something missing ?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 26

Accepted Solution

by:
Shaun Kline earned 500 total points (awarded by participants)
ID: 41765605
Try without the @ symbols. That formula was built using the spreadsheet.

=IF([Date Completed]<>"", "Closed", IF([Effective Date]<>"", "Pending Open", "Open"))
1
 

Author Comment

by:vpopper
ID: 41765767
Works Great!  Thanks
0
 
LVL 26

Expert Comment

by:Shaun Kline
ID: 41766843
Glad to hear it. Don't forget to close out the question so the answer provided can become part of the EE knowledge base.
0
 
LVL 26

Expert Comment

by:Shaun Kline
ID: 41793207
Per the author of the question, the provided solution "works great".
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
A short film showing how OnPage and Connectwise integration works.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

932 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now