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

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?
Answers
-
Hi @Cecilie
Using the TODAY function will cause this. Please see this help article for solutions:
Hope this helps!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!