Activate/Deactivate a Checkbox

Courtenay

Is it possible to activate/deactivate a checkbox, based on the value in another cell? For instance, I have a sheet where users enter data via a form. Then there is a "DQ_Check" column with an IF statement that returns "TRUE" or "FALSE" to indicate that all required fields are valid. If that statement returns true, I want the checkbox in the "Approved?" column to activate. If it is false, I do not want the reviewer to have the ability to check the box.

Something like this:

ColA | ColB | DQ_Check | Approved?

john | doe | TRUE | active checkbox

john | | FALSE | no checkbox

JamesB

@Courtenay In you checkbox column, use this formula.

If(DQ_Check@row="True",1,0)