Modifed By and Modified Date changes in each row when sheet is viewed

Cecilie

Hi all

I am having an issue with my "modified by" and "modified date" columns. Sometimes, but only sometimes, when someone views the sheet, it changes all rows in each column to that person and that date, effectively erasing the data beneath.

It seems the culprit might be my TODAY formula, which is set up like so;

=NETWORKDAYS(TODAY(); TODAY())

I use it to prevent automation from sending emails on the weekends. I can see that in the rows where it is not active, the rows are unchanged.

Thing is I don't understand why the formula is affecting these columns, and why it only happens sometimes. I'd prefer to keep my Helper Column too, as we have several sheets that are already sending out a lot of emails.

I saw that this error has been posted several times before, but I couldn't see a solution anywhere. Any ideas?

ker9

Hi @Cecilie

Using the TODAY function will cause this. Please see this help article for solutions:

Automatically update the TODAY function in formulas | Smartsheet Learning Center

https://help.smartsheet.com/articles/2482767-automatically-update-today-in-formulas?_ga=2.170591847.654502653.1697995780-17946449.1689099335&_gl=1*up7per*_ga*MTc5NDY0NDkuMTY4OTA5OTMzNQ..*_ga_ZYH7XNXMZK*MTY5ODA1ODYyMi4yMDUuMS4xNjk4MDU4ODMzLjM1LjAuMA..

For the TODAY function to recognize what the current date is, the sheet must be updated and saved.

Hope this helps!