Activate/Deactivate a Checkbox

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!