I'm trying to create a automated system in Smartsheet's that takes criteria from a form submission (Unit, Start Date, End Date, Day of the Week and Shift time) to cross check another Smartsheet that has the full calendar year by week and if all criteria from the submission match on the calendar sheet for the particular(Unit, week range, day, and shift time) will subtract from the max available spots using the student count entered in the submission. Is there a formula that can do this? I've tried using a countif formula of all criteria with no success.
Help Article Resources
Check out the Formula Handbook template!