
Announcements
All,
I have a request from a user to create a sign-up sheet for employees. There are 2 dates the employees can select from, but only 250 spots per date.
I need to have the dates become unavailable once a 250 limit it hit for each date. Not really sure how to accomplish this.
The 'Game' column is the date picker for the dates they can select from.
hi, you could use countrows() to do this. for example, lets say your SharePoint list is called BookedDays and the date is in a column called date.
CountRows(Filter('BookedDays','Date' = DateValue("23/06/2021"))
this would return a count of rows where the date is 23/06/2021