New answers tagged

0 votes

Calculated Column formula to find two values in column

You could also use an OR statement: =IF(OR(Content="Urgent",Content="Date"),"Yes","No")
Sturm68's user avatar
  • 21
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
0 votes
Accepted

SharePoint List counting number of days depending upon status

You will not be able to achieve this requirements using Today() in SharePoint calculated column formula because calculated column value is calculated/updated when: You create a new list item. You ...
Ganesh Sanap - MVP's user avatar

Top 50 recent answers are included