YES/NO or just YES

Dorcas Spencer

Yes/No questions - is it better to just have a box to check if the answer is Yes or to have two options a Yes and No option? Welcome your thoughts/ideas on this one as I'm hoping to get two groups to agree on one method. Thanks.

Joanna Waligora

I would say this depends on your audience. Technical folks tend to prefer structured, minimalist approaches, while non-technical users often prefer more context and verbiage. Neither group can deny that check boxes are easier/faster to populate.

If you're going to use formulas based on this value, then a checkbox may be preferred since the two options are just 1 and 0. In extreme cases where the sheet size is VERY large, there may be calculational efficiency gains associated with relying on a binary representation. In all fairness though "Yes" and "No" are not exactly cumbersome to work with, so letting your audience call the shots here is likely your best bet.

Andrée Starå

Hi @Dorcas Spencer,

To add to Joanna’s excellent advice.

Keep in mind if the column(s) will be used in a form process and how you’d want the form to look/function as well.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Dorcas Spencer

Thanks for the tips...

Andrée Starå

@Dorcas Spencer

You're more than welcome!

I'm always happy to help!