Compare 2 Multi Select Drop Down Columns
I have 3 columns, all have the same multi select drop down options. I want the first column to be my selection, the second column is more of a checklist of what's complete, and the third column tells me what is left to be completed from the first column. Any idea if this can be done? Tried using collect formula.
Best Answer
-
Unfortunately not. Another option would be a series of helper checkbox columns and a nested IF statement. Check the boxes that are present in the second column then use the nested IF to output each of the options that are not selected.
Answers
-
Someone else recently had a similar challenge and we realized that (unfortunately) the only way to make this work would be to parse one of the first two columns out. How many entries do you expect to be the max in a single cell?
-
I was hoping there was a better solution than parsing it out! There is about 10 drop down options, I'd rather not make a long formula to account for that. I hoped there was a way to use Collect that I was not thinking about.
-
Unfortunately not. Another option would be a series of helper checkbox columns and a nested IF statement. Check the boxes that are present in the second column then use the nested IF to output each of the options that are not selected.
-
Ahh, trying to avoid helper columns 😋. I appreciate the help though. Good ideas I may be able to work with.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K 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!