i'm working on an android app where I send checkboxes values to a google sheet. My issue is that, I got value for TRUE = 1 and value for FALSE = 3 in my cells. I need the data in the form of when the checkbox is TRUE = Done and when it's FALSE = Undone.

CodePudding user response：

From the Class Range You can use:

insertCheckboxes(checkedValue, uncheckedValue)

If your building the data validation programmatically then use:

requireCheckbox(checkedValue, uncheckedValue) from your DataValidation Builder