Google-sheets – “Superset” Checkbox

google sheets

I have two checkbox columns E and F. I want F to be the "superset" checkbox column, meaning that every checked cell in E means the corresponding cell in F must be checked as well.

I can populate column F with something like = IF( E3 = TRUE, TRUE, FALSE); however, this way the unchecked boxes (corresponding E cells are FALSE) won't get triggered by mouse clicks. How can I achieve this?

Best Answer

In order to mark as checked a checkbox when other checkbox is checked but still able to uncheck/check the first checkbox directly you will have to use an on edit / on change Google Apps Script trigger.

For a general overview about extending Google Sheets through Google Apps Script, please read https://developers.google.com/apps-script/guides/sheets

Related Solutions

Google-sheets – Case insensitive character string filter for multiple individual columns (dynamic input for each)

It appears that you are using regexmatch just to test string equality. This isn't necessary, equalities can be entered simply as Data!A:A = A1. You don't even need lower, because string comparison in filter is case-insensitive:

=filter(Data!A:R, Data!A:A = A1, Data!B:B = B, Data!C:C = C1)

(Also, there is no need for single quotes around sheet name when it does not contain spaces.)

Google-sheets – How to create formula for corresponding data across two sheets

Place this in cell E19

=ARRAYFORMULA(if(ISBLANK(C19:C29),, VLOOKUP(C19:C29,Rates!B2:C24,2,False)))

It will look up the values from the Rates sheet and apply them, and do this for rows 19-29. If there is no value in column C it will return no value.

The Arrayformula and use of array ranges, C19:C29 applies this to every row in that range. The IF test the cell in column C. If it is blank, the test returns TRUE. Since we have ,, taking us past the IS TRUE portion of the IF statement, we return no value when cell C is empty. When cell C has a value, we look that up in the Rates sheet via VLOOKUP() and return the second column of the range we search. The FALSE for VLOOKUP means the data does not have to be sorted so it looks for an exact match as opposed to the first closest match.

Best Answer

Related Solutions

Google-sheets – Case insensitive character string filter for multiple individual columns (dynamic input for each)

Google-sheets – How to create formula for corresponding data across two sheets

Related Topic