Force choice between columns

Dave Wilderman

I tried searching the boards, but not sure that I'm asking the question the right way. Essentially, I'm looking to know the following:

Within the Smartsheet worksheet, I have two columns both set up in a checkbox format. I'd like to restrict my users from checking both accidentally as it should be an either/or scenario. Can I force the columns to only check one or the other? Or am I making this too complicated and it should just be one column with drop-down option?

Andrée Starå

Hi Dave,

No, but we maybe could add a message or change the colors.

Would that work/help?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

 

Paul Newcome

One Single Select Dropdown column would be the safest way to go. If you wanted to maintain two checkbox type columns, there is no way to only allow one or the other to be checked. The best thing you can do is use a combination of helper columns, formulas, conditional formatting, and Automations to help guide people into only checking one box.

Andrée Starå

Yes, I agree with Paul. The best option if you don't need the checkboxes would be a single option dropdown.