Forum Discussion
Conditional formatting a column
Hi there….I am relatively new to Sharepoint. I have a column for ‘date completed’ and a column for ‘time to complete’. The ‘time to complete’ column subtracts the ‘date completed’ from the ‘dat...
Philecowan you don't need JSON for this, just get the formula on the Time to Complete calculated column to check if the Date Completed column is blank. If it is then display nothing, otherwise calculate the difference in days.
=IF(ISBLANK([Date Completed]),"",DATEDIF([Date of Entry],[Date Completed],"D"))
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
- Thanks Rob - worked like a dream
