SharePoint IF AND OR formula

0
votes

I have been working on a calculated column formula and have gotten stuck.

I have a list with several columns the formula is looking at. First column is a Due Date column that is a simple calculated column of Created date + 4 days The Second column is a Completed column. The three options here are empty(blank), Working and Yes The formula I'm working on is for a Reassign column which will ether be a Yes or No. The conditions are If the Due Date is greater than the Modified date and the Completed column is ether Working or empty(blank) then the Assigned column should be No. IF the conditions are not met then reassign column should be Yes

The below formula works except if the Completed column is empty(blank). I've tried using ISBLANK but have had no luck. I believe it maybe a simple formatting issue but any help would be greatly appreciated.

=IF(AND([Due Date]>Modified,OR(Completed="Working",Completed=" ")),"No","Yes")

2
sharepointsharepoint-2010sharepoint-2013
If you're still looking for help, I recommend asking for more guidance on SharePoint.StackExchange.com That community is a bit more focused on the ins and outs of SharePoint as a platform, whereas this community is more focused on programming. There's some overlap, but it sounds like your question is more suited for their advice. Good luck! - Thriggle

2 Answers

1
votes

Your calculated formula would work with using ISBLANK

IF(AND([Due Date]>Modified,OR([Completed]="Working",ISBLANK([Completed]))),"No","Yes")

I always try to use ISBLANK, instead of checking for =" ".

0
votes

To make things simpler, I would flip your logic. Instead of checking that Completed is blank or "Working", check that it's not "Yes".

=IF(AND([Due Date]>Modified,NOT(Completed="Yes")),"No","Yes")