I am creating a work schedule where the staff enters their own schedules. I only want a certain number of staff each shift. I already use
COUNTIF to show the number of staff signed up for each shift. How can I restrict entry into the staff members' cell if the
COUNTIF cell has reached the maximum number of staff?
For example, if I have ten staff members and only need six each day, can I restrict staffing by those other three by blocking entry to those cells?