Forum Discussion
Solved
Sharepoint Online list calculated column with todays date not updating automatically
I have a calculated column in SharePoint online list for calculating the number of days took to complete a task. The calculation is like todays date -task assigned date it gives the correct result wh...
Anzil375 you would need to use a flow in Power Automate to loop through the list and do the calculations on each item. The trigger would be a recurrence schedule trigger. But it couldn't update a calculated column so you'd need to make the column for the number of days a number column.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
waldek
Microsoft
MicrosoftThis is by design. Calculated columns are computed only when editing the item.