[FAQ000171]I want to check the checkbox according to the value retrieved from the table

Q

Is it possible to change whether a checkbox on a sheet is checked or not,

based on the values registered in a table?

A

When reading a value from a table to a sheet,

you can change the presence or absence of a check by once reading the value into a cell

by once reading the value into a cell other than the check box and then re-setting

the CHECK function formula specifying whether or not to check based on the value.

For example, if you have a check box "true" stored in the table,

and you want to apply it to the check box in cell B1, the following steps are required

1. Read the value into any cell in the action (in this example, into A1 cell)

2. Set the following formula in B1 cell with the "Set [] to cell []" action

"="=CHECK(" & A1 & ", """")""

* It will look something like this.

"Set [ ="=CHECK(" & A1 & ", """")" ] to cell [B1]"

Related keywords

CHECK