Forum Discussion
Sharepoint Calculated Date columns
Hi All I have 3 date columns in Sharepoint (Completion Date, Next Review, Last Review). I want to calculate the next review column and last review column so they are dynamic. The completion date sho...
AndyC2235 SharePoint will update the calculated columns at the same time and it won't therefore know what the previous next review date was. It would be much better & easier to do it with a flow in Power Automate where you can store the current value in a variable and then do the calculations in the flow and update the list item.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
Rob_Elliott Thank you. I'll do that instead.