How do I get a alert sent daily when only one column is updated?

Yvonne Stamm
Yvonne Stamm ✭✭✭
edited 02/14/24 in Smartsheet Basics

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

  • JamesB
    JamesB ✭✭✭✭✭✭
    edited 02/14/24

    @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.