Smartsheet Modified at cell capturing on Log in issue

Mark Ondrechak
edited 11/28/23 in Formulas and Functions

We are trying to build an end of day report that shows the updates that were made to open tickets throughout the current day.

However, for some reason every day when my user logs in, the sheet seems to capture changes to every cell marked "Open" in the sheet, and the modified date to all the open rows in the sheet gets updated.

Does anyone have an idea as to why the modified date is changing even if no changes are being made??

  • Filter on the report
  • Report showing all the tickets modified a the same time by the same user at the time she logged in


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!