Modifed By and Modified Date changes in each row when sheet is viewed
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;
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?
Help Article Resources
Check out the Formula Handbook template!