Automate the selection of values from a Multi-Select Dropdown
Good day
I am trying to select values from a Multi-Select Dropdown by using an IF formula. Is this possible?
I dont want to manually have to select the applicable values from the multi-select dropdown selection, but instead the formula should select the multiple values in the dropdown.
Regards,
Pierre
Best Answer
-
The best way I have found for this would be to add in a helper row. It is your choice where you add it, but I am going to use Row 1 for my example on how to set it up.
In the helper row, you would enter each value you want populated for the checkboxes in the appropriate checkbox columns. So based on your screenshot it would look something like this (f is the formula to be provided)...
Completed Milestones..........Checkbox a..........Checkbox b..........Checkbox c
..................f.......................................a.............................b.............................c
..................f
..................f
..................f
Then the formula in the [Completed Milestones] column would pull from Row 1 (or whichever row you use for your "helper row") based on the boxes that are checked "@row".
=JOIN(COLLECT([Checkbox a]$1:[Checkbox c]$1, [Checkbox a]@row:[Checkbox c]@row, 1), CHAR(10))
Answers
-
It could be possible. Are you able to provide more detail as to your workflow? Screenshots with sensitive/confidential data removed, blocked, or replaced with "dummy" data would also be very helpful.
-
Hi Paul
I have attached a screenshot.
Typically I would like the formula to select 'a' only when checkbox 'a' has been checked. Then when checkbox 'b' has been checked, 'b' should then be included as part of the completed milestone selection.
Thanks for the assistance.
Thanks!
Regards,
Pierre
-
The best way I have found for this would be to add in a helper row. It is your choice where you add it, but I am going to use Row 1 for my example on how to set it up.
In the helper row, you would enter each value you want populated for the checkboxes in the appropriate checkbox columns. So based on your screenshot it would look something like this (f is the formula to be provided)...
Completed Milestones..........Checkbox a..........Checkbox b..........Checkbox c
..................f.......................................a.............................b.............................c
..................f
..................f
..................f
Then the formula in the [Completed Milestones] column would pull from Row 1 (or whichever row you use for your "helper row") based on the boxes that are checked "@row".
=JOIN(COLLECT([Checkbox a]$1:[Checkbox c]$1, [Checkbox a]@row:[Checkbox c]@row, 1), CHAR(10))
-
Hi Paul
Thanks for your response.
Yes it works great, thanks for all the assistance.
Just a question, is it possible to instead be selective which columns to look at, instead of a continues range of cells? So for example if my helper row is in a different reference sheet, I would need to keep both the sheet columns consistent else I will receive an #INCORRECT ARGUMENT SET.
Otherwise all works great.
Kind regards,
Pierre
-
@Pierre Mostert I'm not sure I understand what you're asking.
-
Hi Paul
Thanks again for all the help. No worries about my previous question.
Kind regards,
Pierre
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!