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
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!