Forum Discussion
Updating Calculated Column Automatically
Hi all, I have a calculated column that works, but only when we edit the list or settings, etc. Is there a way to set it so the calculation runs automatically without touching the list? Say daily, ...
Further to the (completely correct) answer by Harish_A , you could also use JSON column formatting on a number column to do the calculation and automatically update the number each day. https://pnp.github.io/List-Formatting/columnsamples/
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver).