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.