Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Nested Sharepoint Statement

Posted on 2016-08-19
8
Medium Priority
?
29 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 11

Expert Comment

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

Author Comment

by:vpopper
ID: 41762698
0
 
LVL 27

Expert Comment

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

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:vpopper
ID: 41765381
Getting error...is there something missing ?
0
 
LVL 27

Accepted Solution

by:
Shaun Kline earned 2000 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 27

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 27

Expert Comment

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses
Course of the Month13 days, 21 hours left to enroll

580 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