Automation the 2nd time a cell is changed?
In an attempt to reduce the amount of emails and notifications that my coworkers have to read, I'm trying to create an automation that only triggers starting from the 2nd time a cell is changed.
I'm working with dates here and I'm looking for a way to basically ignore the cell change from blank to a date, and trigger an automation if it changes from the date first entered into another date.
Any help would be appreciated!!!
Comments
-
Hi Chester,
Unfortunately we don't have a way to do that. Could you tell me more about what makes these alerts relevant? When are they most useful to the user?
I'm wondering if there another set of Conditions on other columns that you could use to have the alert sent only when it is relevant.
--
Scott Willeke | Smartsheet
Director of Product Management
-
Hi Chester,
The third-party service, Zapier could be an excellent option for this scenario. I haven't tested that specific workflow but I think it would be possible.
Also, I agree with Scott. What's the use case?
Is that an option for you?
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hey Scott,
I'd be glad to explain a bit more about my use case!
Basically, this is a standing sheet that we're constantly updating with requests and new jobs, and for our use case, we don't need notifications about a job being added onto the sheet or created. We only need to know if the due date from the job has changed or updated depending on whether or not something has been delayed.
The only columns on the row are Job Name, Assigned To, Due Date, and a checkbox column indicating job completion. Since we only care about whether the due date changes or not, I don't think there's another column to base the notification off of.
Looking at the automation settings, it doesn't look like there's a way to ignore the initial input of data or the creation of the row.
-
Chester:
Thanks for providing more information. You might consider adding an Original Due Date column that is set with the first due date. Then use another column such as Revised Due Date. Then you can trigger the workflow only if Revised Due Date is changed. Add a Condition Block to only kick off the actions in the workflow if Revised Due Date is not equal to Original Due Date.
With the condition in place, you can even put a formula in Revised Due Date that defaults to the Original Due Date and the workflow will only run if the revised Due Date changes.
Hope this helps!
—
Scott Willeke
Director of Product Management
