Multi Select column logic to return results for a separate multi select column
I'm very new so apologies if I can't make sense of my question. I want to create a formula that will take input from column 1 which is a multi select (about 5 choices) column type, and take input from column 2 which is a checkbox column type and then return results in column 3 which is a another multiselect column (about 170 choices). Column 1 is essentially a grouping of choices from column 3, and I would like the user to be able to check column 2 as true to auto assign the choices from column 3, while having the option to set column 2 as false and then manually select their choices from column 3.
I'm still learning the formula so I will try to put the logic in plain language here:
-If group 1 from column 1 and column 2 is true, then column 3 becomes choices 1,3,6,9.
-If group 1 and group 2 and column 2 is true, then column 3 becomes choices 1,3,6,9 AND 2,4,5,7.
And anytime column 2 is false, the user will manually enter their choices fro column 3.
Best Answer
-
Hi @Adam Belohradsky ,
Unfortunately Smartsheet's current functionality won't support what you're trying to do. You can't use a formula to turn off a formula in another column and allow manual entry. The ability to dynamically change drop down options doesn't exist either; without subscribing to a 3rd party solution.
I don't have another solution for you either. There are lots of smart and creative people in the Community. Maybe someone else has an idea for you.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Adam Belohradsky ,
Unfortunately Smartsheet's current functionality won't support what you're trying to do. You can't use a formula to turn off a formula in another column and allow manual entry. The ability to dynamically change drop down options doesn't exist either; without subscribing to a 3rd party solution.
I don't have another solution for you either. There are lots of smart and creative people in the Community. Maybe someone else has an idea for you.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!