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

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"))
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.


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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Suggested Solutions

Title # Comments Views Activity
SharePoint List Calculated Field 4 53
sharepoint list help 2 44
SharePoint Destination SSIS 2 37
DataTable column sorting incorrectly 2 17
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…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
In a recent question ( here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question ( here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

740 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