3
try the below formula, add the below formula in the status - calculated column
=IF( ISBLANK([completed]) , "Open" , "Closed" )
2
Try using below formula, it will work for you:
=IF(ISBLANK([completed date]),"Open","Closed")
Note:
Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
Return your calculated field as Single line of text.
Example:
Column ...
1
Try using below formula:
=IF(AND([impact]="High", [Urgency]="High"), "Crisis - SEV1", "Low Severity")
Note:
Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
Return your calculated field as Single line of text.
You can ...
1
Try this:
=IF(ISBLANK(DateThree),(DateTwo-DateOne),(DateThree-DateOne))
1
In addition to Martiur's response, to calculate the number of days you can use the DateDif function:
=DATEDIF(Start_date,End_date,"D") -> "D" for number of days.
E.g.:
Create a calculated column of type number
Formula
=DATEDIF(Today(),[PastDate],"D")
Microsoft Article
1
Based on many references on this in Stack Exchange,
you can use Today() instead of [Today] like:
=TODAY()-DateOne
1
Well, you are formatting the result to show only the time value, so what do you expect?
In Excel, you can use the [] brackets to show values greater than 24 hours in the hour part. Not sure it works in SharePoint, but you can try.
"[hh]:mm:ss"
Only top voted, non community-wiki answers of a minimum length are eligible
