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)
I have a Control Center program that creates a project management sheet for each new project. In the Intake Sheet we have a contact column "Project Manager" where Control Center pre-populates the project manager's contact name in every row, of the project, where the project manager oversees the task associated with that…
I am looking for a formula that will look at this table and pull the hours per week based on 2 criteria – group and week. Right now, I have the tables separated so that I can use a vlookup formula. But that means I have to have 5 different formulas, 1 for each group. =IFERROR(VLOOKUP(ROUND(($[First Receive]@row - $[Week 1…
Hi, I am needing to create a column that will display the correct month based off a date in another column. My columns are below. I am not certain on which formula to use. Thanks for the assistance!
