I use Smartsheet for work and I have a set of automations that work in tandem to create a daily report for me and my colleagues. I set up these automations over a year ago and haven't touched them since. However, part 2 of the set stopped working randomly about 3 weeks ago.
Part 1:
Trigger: When rows are added or changed on Sheet_1
When: Column_1 changes to any value OR When: Column_2 changes to any value » run workflow: Change Column_3 cell value to "1" for the rows that were changed
Part 2:
Trigger: When a date is reached, every day starting a year ago at 3pm CST.
Condition: Where Column_3 is one of "1"
Alert Someone: Send to specific people with a message including {{ }} (message includes links to sheet and all fields)
Change a Cell Value: Change Column_3 cell value to "0" for the rows that were previously "1"
Anyone have any insights?