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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives