Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Is there a way to make only allow the user to select one checkbox? If they choose one, the others are unchecked? I have a survey with 5 options (1 checkbox for each). If the user selects #1 but then selects #2, I need #1 to uncheck.
Hi Michelle,
Unfortunately, it's not possible at the moment in Smartsheet, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
As a workaround, you could use a third-party integration like Google Forms.
Is that an option? Would that work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Use a Dropdown List or the Symbols column type.... especially if you would like the "happy" to "sad" faces (aka pain levels).
Could you use a drop-down column for their choice? Then if you need that answer to correspond to a checkbox on the sheet, you can hide the drop-down column and add a formula to the checkbox columns for each survey answer.
example: =IF([Survey Answer]@row = "Very Happy", 1, 0)
Hello, We have several automations configured to copy a row to another sheet when specific criteria are met. Recently, these automations have been intermittently failing. For example, they worked this morning but stopped working this afternoon, and then they often begin working again the following day without any changes…
I have team member specific, multi project sheet, prefiltered Reports built out and I want to have these reports automatically emailed to the team member and myself every Monday morning before I'm in the office. The reports run off of the "Last 7 days" filtered for tasks accomplished. So having them automated to run and…
I'm trying to create a formula in sheet #1 that: Looks up all rows containing a certain email address in sheet #2 References a certain value in those rows (the values in question are themselves average formulas) Takes the average of all those specific values Displays that average back in sheet #1 I know there are formulas…
