0

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 agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.