Was Form Updated Today?
hi... i have a form where everyday I need a status update on a multiple facility names. Is there a formula to determine which facility name did not receive an update today, based on modified date?
Answers
-
Hey @Joan B
Many changes, sometime inadvertent, will affect the modified date which makes the mod date a tricky field to use reliably. A more robust approach would be to add a helper date column and use the Record Date automation to record the date automatically when the status column changes (or whatever column is being updated daily). You could then have a second automation that runs once a day after the updates should come in, and looks for dates that do not equal TODAY to send you the notification.
I'm happy to help you build the automated workflows if the above is of interest. They are both very straight-forward to add if you haven't used them before.
Kelly
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives