I want to create a spreadsheed using Google Drive in which some columns entries should be retricted based on given value. E.g.: I have some columns named users, item1, item2. In columns item1 & item2 I like to have only maximum 5 users that can make one entry. If more than 5 users try to make an entry, then it should show the message like you can’t make an entry.

How can I do this?

1 Answer 1


Please try Data, Validation.... with a the Criteria: a Custom formula is of the kind:


and On invalid data: Reject input.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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