I am creating a list for an upcoming office party and want to restrict the number of people that choose to bring certain items.
Column Names:
Apple Juice (3 people)
Orange Juice (3 people)
Bottles of water (2 people)
Is there a way to validate or use a calculated column so that when two people choose to bring water or one person chooses to bring two cases of water, the column will not allow any more entries?