Forum Discussion
ChrisWoodiow
Dec 13, 2023Copper Contributor
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 calcu...
Rob_Elliott
Dec 13, 2023Silver Contributor
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)