2

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?

Improve this question
1
  • 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?
    – Frances Davis
    Jan 16, 2019 at 0:39

1 Answer 1

Reset to default
0
  • select rows where they can type and create restricted data validation with this custom formula: 
    =COUNTA($B$2:$B$10)<=$B$1

1

Improve this answer

Your Answer

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

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