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