Why does my Modified Date keep updating when I'm not making changes?
Can someone help point me in the right direction of where to go to submit a ticket for this? For four rows on my sheet (Row 1, 3, 4, 5) every time I save my sheet those rows update the modified date, even though I'm not touching those rows at all. In many cases those rows are filtered out of my view, so it's not even possible for me to update them (there are no dependencies enabled and no formulas in this sheet).
I have automation set up on this sheet to notify users of changes to rows, and they are getting emails every time I save the sheet as a result of this, when there are no actions for them. Why is the sheet doing this and how do I disable it without disabling the automation?
Please see attached activity log showing that only the modified date is changing for those rows, without me doing anything to trigger it.
Best Answer
-
@Win LeDinh Got the below answer from Smartsheet. Could that be the issue you're seeing as well?
After consulting with my senior resources in regards to the issue you are experiencing with the sheet and save button constantly being active when opening the sheet, it appears the sheet is in a state of "Dirty Save".
"Dirty Save", refers to an active save icon on the sheet when it is first loaded, or remaining active after the sheet is saved. This is due to a calculated difference between the data in the client and on the server. Currently there is no way of fixing this, and it seems that the solutions previously provided are you best option.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi Katie,
I've had a few clients that have something similar.
I would recommend that you reach out to the Smartsheet Support Team.
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Do you have any formulas in those rows? Any that could be updating their values based on adding or changing another row?
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thanks all! I do not have formulas in any rows in this sheet. I opened a support ticket and will try to post an update when I hear back.
-
@Win LeDinh Got the below answer from Smartsheet. Could that be the issue you're seeing as well?
After consulting with my senior resources in regards to the issue you are experiencing with the sheet and save button constantly being active when opening the sheet, it appears the sheet is in a state of "Dirty Save".
"Dirty Save", refers to an active save icon on the sheet when it is first loaded, or remaining active after the sheet is saved. This is due to a calculated difference between the data in the client and on the server. Currently there is no way of fixing this, and it seems that the solutions previously provided are you best option.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I am having the same issue where the modified date keeps getting updated even though no user intervention through editing has occurred. This appears to be happening at 3:20AM in the morning when no users are in Smartsheet. Any thoughts on how to resolve?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!