2

Use below formula for your calculated field: =IF(ISBLANK([DATE1]), IF(ISBLANK([DATE2]), IF(ISBLANK([DATE3]), "", [DATE3]+90), [DATE2]+90), [DATE1]+90) 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(,). ...


1

Use any one of the below formulas in your calculated column: ="Sum: " & COUNTA([Step 1], [Step 2], [Step 3]) OR =CONCATENATE("Sum: ", COUNTA([Step 1], [Step 2], [Step 3])) References: CONCATENATE function Count nonblank columns


1

You can do this with a calculated column with a formula like: =COUNTA([Step1], [Step2], [Step3]) Details here: https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=office.14)#count-nonblank-columns Alternatively, you can do this with column formatting with a format like this: { "elmType": "span&...


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