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)
From my research, I understand there isn't a way to keep formulas when exporting from Smartsheet into an Excel document. I have a total of 50 columns with formulas and would think there was a quicker way to grab the formulas. So far, I've appended a "!" which turns the formula into text which does export. However, I'm not…
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
