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.
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.
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!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Thanks for the tips...
You're more than welcome!
I'm always happy to help!
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "Reevaluate/Schedule Final". See the workflow trigger screenshot below. I created this workflow and tested it on 11/16. It…
I use Outlook with my company. When a tagged email comes in from Smartsheets, I click on the "reply in Smartsheet" and it won't take me to any conversation box. It just opens the page, but not on the line that I need. Why is this happening? I updated this morning. Also, I get an Error message sometimes.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.