We have a process where someone should perform some checks every 3 days and use a Smartsheet form to fill out the results.
We want to send a notification if those checks have not been done in 3 days.
I created a helper column. When the form is submitted the value is true.
I created a workflow that if the Date completed of the form is >3 days set the helper column to False. This runs every day.
I created a second workflow that if the helper column does not equal to true send a notification.
A check was done yesterday and there is a value in the helper column of true. But the workflow was sent.
Here is the workflow. How do I make it check the whole helper column and only fire if there is no true in the entire column?
I have a Sheet Summary that counts the 'True's but I cannot route a workflow off a value in sheet summary.
