Event Request - block date(s) when event is full with a formula


Hello! I am creating a form for people to sign-up for an event. There are only so many spots available for these events, so I want to have a date option be greyed/struck-out when the event is at capacity. Is there a formula or conditional formatting that will do this once the event is full? Thinking to use Sheet Summary to have a field where I key the maximum capacity and when that is reached, use that field as my criteria. Thoughts?

Thank you in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!