Solved

Nested Sharepoint Statement

Posted on 2016-08-19
8
18 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
This video discusses moving either the default database or any database to a new volume.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 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

13 Experts available now in Live!

Get 1:1 Help Now