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
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!