Calculated Column Stops Working

Copper Contributor



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!

1 Reply

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