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)
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
am I able to separate this into multiple rows? in a new sheet? Desired Result -
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.