[FAQ000168]I want to implement mandatory checks in the checkboxes on CELF sheets

Q

If an app has multiple checkboxes and none of them are checked,

how do I get an error to occur?

A

There is a possible way to specify all the target checkboxes in the OR function.

e.g.) If there are checkboxes in cell A1 to cell A5

　=OR(A1:A5)

The above expression will

return false if none of them are checked,

and true if any of them are checked.