SharePoint Document Issues

Fix SharePoint Calculated Column Not Updating Today Automatically

Olivia MillerOlivia Miller Nov 2, 2026 870 views

Question details

A SharePoint calculated column that counts days using the current date does not refresh automatically each day.

How to Fix a SharePoint Calculated Column Not Updating Today
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Attempting to track the number of days elapsed from an opening date to the current date using a calculated column.
Observed behavior
The calculated column does not update daily; items continue to show the previous day's value until they are manually edited and saved.
Before you start

Ensure you have access to Microsoft Power Automate and possess the necessary permissions to create, edit, and run scheduled cloud flows for your SharePoint list.

Solution 1Recommended

Use a Scheduled Power Automate Flow to Trigger Recalculation

Create a daily scheduled flow in Power Automate to update a helper column, forcing SharePoint to recalculate the item formulas automatically.

The [Today] token in SharePoint represents the day an item was created or last modified, meaning it does not act as a live clock that updates every day. To force a recalculation, the item itself must be modified.

By setting up a Power Automate flow, you can automate this modification daily. The flow will update a designated helper column with the current date, triggering your calculated columns to refresh without manual data entry.

1
Create a helper column

In your SharePoint list, add a new 'Date and Time' column and name it 'HelperToday' (or similar). This column will be used to receive daily updates.

2
Set up a scheduled flow

Log in to Power Automate, click 'Create' on the left menu, and select 'Scheduled cloud flow'. Name the flow and set it to repeat every 1 Day.

3
Retrieve list items

Add a new step and search for the 'Get items' action from the SharePoint connector. Select your 'Site Address' and 'List Name'.

4
Update the helper column

Add an 'Apply to each' loop using the 'value' output from the 'Get items' step. Inside the loop, add the SharePoint 'Update item' action.

5
Insert the current date

In the 'Update item' action, map the required fields. For the 'HelperToday' field, use the dynamic expression formatDateTime(utcNow(), 'yyyy-MM-dd'). Save and turn on the flow.

Use a Scheduled Power Automate Flow to Trigger Recalculation
Optimizing Flow Performance: If your SharePoint list has thousands of items, updating every item daily may impact performance. Consider adding an OData Filter Query in the 'Get items' step (e.g., Status eq 'Open') so the flow only updates active items.
Free Microsoft Office alternative

Need a simpler way to analyze list data? Try WPS Office

While SharePoint handles list storage and automated calculations, analyzing that exported data in complex spreadsheets is much easier with a dedicated, lightweight office suite. WPS Office provides full compatibility with Microsoft Excel formats, allowing you to manipulate list exports and date calculations without the hassle.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
  2. 2. Export SharePoint Data: In your SharePoint list, click 'Export' and select 'Export to Excel' or 'Export to CSV'.
  3. 3. Analyze in WPS Spreadsheet: Open the downloaded file in WPS Spreadsheet to utilize advanced functions like =TODAY() that update dynamically without needing automated flows.
Fully compatible with Microsoft Excel (.xlsx) and CSV formats exported from SharePointFree, lightweight, and incredibly fast to install on any deviceFamiliar user interface makes data analysis and date calculation easyBuilt-in PDF editing and document conversion tools
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't the [Today] function work dynamically in SharePoint calculated columns?

In SharePoint calculated columns, formulas are only evaluated when an item is initially created or subsequently modified. The [Today] function does not act as a live, dynamic variable that updates on its own; it simply captures the date of the last save action.

Can I use JSON formatting to calculate days from today instead?

Yes. Column formatting using JSON allows you to display dynamic dates and calculate differences between a date column and the @now token. However, this only changes how the data is visually displayed to the user; it does not store the calculated value in the backend for complex sorting or filtering.

Will running the Power Automate flow change the 'Modified By' field?

Yes. Using the standard 'Update item' action in Power Automate will update the 'Modified' date and change the 'Modified By' field to the user account that owns the flow connection. To avoid this, advanced users can use SharePoint REST API calls within Power Automate to perform system updates without altering these tracking fields.