Nested Sharepoint Statement

Posted on 2016-08-19
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!
Question by:vpopper
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 10

Expert Comment

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

Author Comment

ID: 41762698
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"))
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.


Author Comment

ID: 41765381
Getting there something missing ?
LVL 26

Accepted Solution

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"))

Author Comment

ID: 41765767
Works Great!  Thanks
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.
LVL 26

Expert Comment

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

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

635 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