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?

  • On the spreadsheet I have, each employee has their own row. They add their shift type in the cells of each column to create their schedule. Would this formula work with that setup? Commented Jan 16, 2019 at 0:39

1 Answer 1

  • select rows where they can type and create restricted data validation with this custom formula:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.