Team Vacation Planner - automation to notify if too many people are taking the same day off
Is there any way smartsheet can set up an automation that if there are too many people taking the same day off it'll send an alert to me?
I have a start date and end date column
I also have another helper sheet with each day (excluding holiday, Saturday and Sunday) in each row and different departments as column. Let's say if on 7/21, IT department has 3 people off, it will alert me. 11/7, HR department has 5 people off and it'll alert me....etc.
I'm open to any idea and feel free to brainstorm together :)