Forum Discussion
Sharepoint List Formula
Hello,
I am looking to use a calculated cell but can't seem to find a solution.
The cells I am looking to calculate are as follows
Date Received
Date Completed.
I am looking to calculate the age of a report based on date received date completed, but also for open reports date received and [TODAY]
Hope someone one can help!
1 Reply
ChrisWoodiow One thing you need to be aware of is that a calculated column is not dynamic and so will not automatically update every day. It will only update when the item is modified. You could have a single line of text or a number column that is formatted with JSON which is dynamic, or you could have a flow in Power Automate set to run every day which updates that number column with the age.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP (and classic 1967 Morris Traveller driver)
