Data validation applied to tickboxes
Given ColumnA contains a Text header (A1), an allowed maximum number (A2), fifty tickboxes (A3:A62) and a formula in A63 of:
how can I block application of more than the allowed maximum number of ticks, or at least warn that the limit has been exceeded?
There is a Q on Web Applications [WA] that remains unanswered after three months with a problem of the kind outlined above. On WA the tag at present is [google-sheets-query] but why so is not clear to me.