Hot answers tagged

1 vote

How to do an AND statement in amongst nested IF statements

You have to properly open/close the parentheses for AND function like AND(condition_1, condition_2, condition_3). Try using below formula for your SharePoint calculated column: =1-IF([Customer details ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

SharePoint List calculation using current date

Use calculated column formula like this: =IF(ISBLANK([Date Closed]),IF([Due Date]<Today(),"Overdue","Open"),"Closed") Notes: Sometimes comma(,) does not work in ...
Ganesh Sanap - MVP's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible