Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Alert when a row has not been updated in the last 14 days
A project lead has requested an alert that sends to him when a row (assigned to a project manager) has not been updated in the last 14 days.
My attemtps at a solution:
1: Include the system column (Modified - Date)
2: Trying to apply conditional formatting to make it easily visible when viewing
3: Can't seem to work out way to set an alert based on this. Would I need to just send all rows he leads on every 14 days and then he would need to look at the modified column for the formatting?
Any ideas...
Thanks
Comments
-
One idea I might try is to use the reminders function under alerts. You will need to create another Date column based on your last modified column with the equation "=DATEONLY(Modified1)". Then set a reminder on the Date Only Column for 14 days After the DATEONLY field.
See the attached screenshot, I think this would work. There may be other ways to do it, but this seems the simplest to me. Good Luck!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 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
- 289 Events
- 33 Webinars
- 7.3K Forum Archives