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"?

=IF(D5=true,false,true)

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.