Can a similar script be used to return a checkbox if any of the previous 4 columns are FALSE, or return 'N/A', if the previous columns are false?
It's a Harry Potter fitness exercise, that allows 2 Tardy Passes per term; I'd like to leave a checkbox available to be checked if a Tardy Pass is not used, and replace the following weeks' columns' checkboxes with 'N/A' if a Tardy Pass has been used. There are 2 rows, 1 row for each Tardy Pass. And 8 columns, 1 column for each week of the 'term'.
:)