SPO Calculated Column not updating date

Frequent Contributor

Hello, I am in SharePoint Online and I have a modern Lists list.

I have a calculated column "Alert Age" which uses the Calculated column of number.

 

=TEXT(DATEDIF([Date Reported],TODAY(),"d"),"#")

 

The issue is that some of the columns are not being automatically updated.  Some are not being displayed.

 

Below shows the date of 11/19/2021 (this has been created presumably on that date or around it so it is not something that was updated "minutes ago") show the Alert Age of 12, which is not true, it is closer to 30.  The date of 09/16/2021 shows 29 days which is also incorrect as it is more than a few months old and not 29 days.

 

 

2021-12-10_14-45-27.png

 

I don't know if I should open a ticket with Microsoft.  I don't know that there is anything that I can do in my environment as a calculated column is running presumably at midnight to update with "Today" yet the date, when entered or updated, should reflect the correct date.

The other issue is IF we have to go in and edit the date reported, even to copy and paste, is that something that SHOULD be done!?  And if so, done multiple times if this happens again?  

We want to get analytical data off of this and possibly create Power Automate flows to ensure that if it has been a month to alert someone or take action or update a field, etc.

 

Thank you!

Matt

1 Reply

@Matthew Carter Calculated column values are calculated & updated only when:

  • A new item is created
  • An existing item is updated
  • Calculated column formula is updated

So, using Today() in formula does not update the value on daily basis.

 

Check this thread for more information: Count not updating in calculated column 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.