SharePoint IF/AND statement

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

Accepted Solution

Shaun Kline earned 500 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SharePoint 2010 - migrate MySites to a new server? 5 46
Sharepoint workflow on list 6 39
server program files 24 61
Sharepoint 2013 Library List View Limitations 9 56
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 (…
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

786 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