LASTED UPDATE FIELD SETS EVERY ENTIRE COLUMN TO DAY THE SHEET WAS OPENED

Fialko66

I have a column on a sheet set to modified date but the date sets to the date/time the sheet was last opened rather than the date the row was updated in every cell in the column. Can anyone tell me what i am doing wrong please?

I want the date the actual row (any cell) was updated so i can set a reminder if it's not been updated in a while

Thanks

Nick Korna

Hi @Fialko66,

Do you have any formulas in the sheet? I had a similar issue to yours and a column formula with TODAY in it was the culprit.

Fialko66

https://community.smartsheet.com/discussion/comment/403859#Comment_403859

Hi - Yeah, I have a few formula's in the sheet but none of them use a TODAY formula. Must be a glitch in the field type