Forum Discussion
Stop counting days in SharePoint when status value is 'Complete'
I have a 'DAYS OPEN' calculated column, which begins counting from the date 'RECIEVED', =TODAY()-RECIEVED and a 'STATUS' choice column, New Assigned In Progress Pending More Information Comple...
SvenSieverding , is there a way we can do this without JSON? Can you share an example?
rinaldoperez no there isn't, you can't do this with a calculated column for the reason that SvenSieverding gave. He gave you the best advice, and you don't need to write your own JSON, just paste the JSON Sven gave into the advanced mode formatting box for the column. It's that or a flow.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)