Forum Discussion

Szymciak's avatar
Szymciak
Copper Contributor
Jul 19, 2023

Calculated Column Stops Working

Hi,

 

On my list I am using a simple formula to calculate the number of days between Today and Modified column dates.

 

=DATEDIF([Modified], TODAY(), "D")

 

After a while it stops calculating properly until I go into it and paste the formula again, there is a number of files which have been modified on the same day, but they all give different values.

 

I noticed it changes [Modified] to Modified as well, but I'm not sure if that's the reason.

 

Does anyone have any ideas? Thanks in advance!

Document Library
Microsoft Lists
SharePoint Online
  • KotiReddy's avatar
    KotiReddy
    Brass Contributor
    Jul 19, 2023

    Szymciak If you sure on this get audit logs from compliance center for list column updated. Check if something can be found there.

Resources