Improve company productivity with a Business Account.Sign Up


SharePoint IF/AND statement

Posted on 2016-08-19
Medium Priority
Last Modified: 2016-08-19
I am trying to get this nested statement to work in SharePoint however, doesn't seem to be working.  Any ideas?

=IF(AND([Date Completed]=””,[Effective Date]=””,””,Pending”)

If both are true, I want null value.  If both are false, I want "Pending"

Question by:vpopper
  • 3
LVL 27

Accepted Solution

Shaun Kline earned 2000 total points
ID: 41762423
The formula syntax does not look correct. You appear to be missing an end parenthesis.

=IF(AND([Date Completed]=””,[Effective Date]=””),””,Pending”)

Don't know if that will provide you the correct results though.

Author Comment

ID: 41762513
This one does not work either...thanks for trying but still need help on this one.

Author Comment

ID: 41762531
Got it - it was missing " before Pending.


Author Closing Comment

ID: 41762532

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.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

589 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