Hello.
I have a list of people who need to select training dates from a list available.
I have created a Data Validation drop down menu for the people based off a list of classes available.
I have also created FILTER formulas to sort the attendees into attendance lists.
My only issue left is that there is a limit for how many people can attend each class. I would like to impose a condition to not allow a date to be selected from the drop down menu once the count of participants reaches 25.
However, if I try to impose a =IF('Sept 6'!D3=<25,"sept 6",""), I have to turn on Iterative Calculation, which tends to mess things up a little bit.
"Circular dependency detected. To resolve with iterative calculation, see File > Spreadsheet Settings.", once I turn on Iterative Calculation (which I've never used before) I'm not sure about what settings to select there.
Anyways, any help would be appreciated to impose a condition or limit to number of times a drop down menu selection may be selected.
Thanks in advance!
I have a list of people who need to select training dates from a list available.
I have created a Data Validation drop down menu for the people based off a list of classes available.
I have also created FILTER formulas to sort the attendees into attendance lists.
My only issue left is that there is a limit for how many people can attend each class. I would like to impose a condition to not allow a date to be selected from the drop down menu once the count of participants reaches 25.
However, if I try to impose a =IF('Sept 6'!D3=<25,"sept 6",""), I have to turn on Iterative Calculation, which tends to mess things up a little bit.
"Circular dependency detected. To resolve with iterative calculation, see File > Spreadsheet Settings.", once I turn on Iterative Calculation (which I've never used before) I'm not sure about what settings to select there.
Anyways, any help would be appreciated to impose a condition or limit to number of times a drop down menu selection may be selected.
Thanks in advance!