I have a Google Spreadsheet with check boxes in four adjacent columns. I want to drive the user to select one check box (of their choice) and have the others default to "false". The formula below works for two columns - how do I expand it for four columns and retain the users ability to choose which column is "true"?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.