Is it possible to have multiple "and" in a trigger?
I have a very basic sheet where 9 different users go in to check a box for their locations once they have completed a task. Once all these nine boxes are all checked, I need an alert to go to a different group of people so they can complete out their task. Once they complete out their 2 tasks but checking 2 different boxes, then a new task going back out to the original 9 people to complete the secondary task. What is the best way to set up this automation. I don't think a formula will work this example but open to suggestions.
Best Answer
-
@Amanda - Scout Mom Yes, you can just set an automation that when any changes occur to activate ONLY if all 9 columns are checked.
Then it will trigger something to someone(s). Hope that helps.
Answers
-
@Amanda - Scout Mom Yes, you can just set an automation that when any changes occur to activate ONLY if all 9 columns are checked.
Then it will trigger something to someone(s). Hope that helps.
-
Thanks - new to Smartsheet and under a time crunch. This worked great.
