How do I get a alert sent daily when only one column is updated?
Needing a workflow that will send out a daily email with all rows that the priority has been changed. It doesn't matter if the other columns changed, but I need to know if the priority changed and I only want it once a day. Currently using Enterprise no additional add ons.
Answers
-
@Yvonne Stamm The easiest way to do this is with a helper column. You can create a column named Priority Change as a text column, then you can create an automation to set the number 1 in this column when the priority cell changes. From there, you can create an automation to run daily that looks at the helper column for the number 1 as the filter criteria to create your automation. and also changes the cell back to 0 in the helper column so that it will not be caught by the next run of the automation until it's priority changes again.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives