Change Cell Automation Based on Count of Items
I am trying to create an automation that a waitlist column is "checked" when the total registrations exceeds 10. I've done this before using the auto-number feature to count registrations as they come in from the form, and then created the automation based on that column.
However, I am trying to do this now based on people having two time options to choose from and the numbers are capped at 10 per session. Is it possible to build an automation to automatically check the waitlist column if registrations for each time option exceeds 10?
Help Article Resources
Check out the Formula Handbook template!