Forum Discussion

robmatey's avatar
robmatey
Copper Contributor
Jun 19, 2025

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, etc. 

Lists
SharePoint Online

2 Replies

Sort By
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Jun 20, 2025

    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).

     

     

  • Harish_A's avatar
    Harish_A
    Copper Contributor
    Jun 20, 2025

    Hi robmatey​ , SharePoint doesn’t automatically recalculate values unless an item is updated. To work around this, you can set up a daily Power Automate flow to update the items and trigger the calculation.

Resources