Formula for Multiple Checkboxes
I have a sheet with submission form, in the form there are two different sections. One where they have to pick a checkbox option from a list of 4 and the other is one out of 8. I set it up this way to be able to provide details for each selection.
I'm trying to find a formula in the sheet so I can hide all the checkboxes and have two columns that auto-populate what was selected via checkbox in the two different sections of the rows. Their selections will be limited to 1 Job and 1 Department.
Thanks,
Spike
Answers
-
@Spike I am not sure I completely understand what you are asking. I would think that using a dropdown field so they can select an option would be more efficient. Then I could help you build a formula to display their selections in once field (if that's what you are looking for). If I am understanding correctly, the reason you created multiple checkboxes and ask them to select one is because you wanted to be able to explain the options they are selecting from. Have you considered doing something similar to what I have done in the screenshot below?
Melissa Boehl
Smartsheet Architect | TurningPoint Energy
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!