Reminder/Alert Automation
I have this tracking ticket Smartsheet where every 2 weeks, my team of 4 analyst rotate on who's in charge of addressing these tickets. These tickets don't have deadlines, they just have quality information (e.g. ticket name, description, submitter, status, location of issue).
I want to create an automated reminder for every 2 weeks to the specified rotating analyst. Is this possible in Smartsheet?
Best Answer
-
Yes, you can set up an automated reminder in Smartsheet for rotating responsibility every two weeks. While Smartsheet doesn’t directly support a recurring “rotation” feature, here’s a workaround to achieve it:
Step 1: Create an Assignment Column
Add a column (e.g.,
Assigned Analyst
) where you specify the analyst responsible for each two-week period. You’ll rotate through this list every two weeks.Step 2: Set up a Reminder Date Column
Create a new column (e.g.,
Reminder Date
) with a date that aligns with the start of each two-week cycle. You’ll update this date manually or set a formula to increment it every two weeks.Step 3: Set Up an Automated Workflow for Reminders
- Go to Automation > Create Workflow and choose Alert Someone.
- Set the Trigger to check every two weeks on your desired day (e.g., every other Monday).
- In the Condition block, add a filter to check that the
Reminder Date
matches today’s date. - Set the Action to send an alert to the email listed in the
Assigned Analyst
column.
Step 4: Adjust the Analyst Rotation
To automate the analyst rotation, you could:
- Manually update the
Assigned Analyst
column every two weeks. - Alternatively, use a helper sheet to track the rotation and reference this in the main sheet.
Optional: Use a Report to Track Upcoming Reminders
To easily monitor or adjust upcoming reminders, create a Smartsheet Report that filters for rows with upcoming reminder dates, making it simpler to update your rotation.
This setup will provide an automated two-week reminder to the designated analyst, with minimal manual adjustments needed for rotating assignments.
Feel free to reach out with any additional questions!
Murphy Carlson
DigitalRadius, Smartsheet Platinum Partner
mcarlson@digitalradius.com
Answers
-
Yes, you can set up an automated reminder in Smartsheet for rotating responsibility every two weeks. While Smartsheet doesn’t directly support a recurring “rotation” feature, here’s a workaround to achieve it:
Step 1: Create an Assignment Column
Add a column (e.g.,
Assigned Analyst
) where you specify the analyst responsible for each two-week period. You’ll rotate through this list every two weeks.Step 2: Set up a Reminder Date Column
Create a new column (e.g.,
Reminder Date
) with a date that aligns with the start of each two-week cycle. You’ll update this date manually or set a formula to increment it every two weeks.Step 3: Set Up an Automated Workflow for Reminders
- Go to Automation > Create Workflow and choose Alert Someone.
- Set the Trigger to check every two weeks on your desired day (e.g., every other Monday).
- In the Condition block, add a filter to check that the
Reminder Date
matches today’s date. - Set the Action to send an alert to the email listed in the
Assigned Analyst
column.
Step 4: Adjust the Analyst Rotation
To automate the analyst rotation, you could:
- Manually update the
Assigned Analyst
column every two weeks. - Alternatively, use a helper sheet to track the rotation and reference this in the main sheet.
Optional: Use a Report to Track Upcoming Reminders
To easily monitor or adjust upcoming reminders, create a Smartsheet Report that filters for rows with upcoming reminder dates, making it simpler to update your rotation.
This setup will provide an automated two-week reminder to the designated analyst, with minimal manual adjustments needed for rotating assignments.
Feel free to reach out with any additional questions!
Murphy Carlson
DigitalRadius, Smartsheet Platinum Partner
mcarlson@digitalradius.com
-
@mcarlson Thank you so much! This was very helpful!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives