Multiple Selection - Formula

Mike Rini

Hi -

I have a question re: a Multi-Selection Drop Down. Right now, our one multi-select has 120 options. More often than not, people select less than 5 from the drop down. When they select from the drop-down, I have to parse what they select into codes. E.g. - Selection 1 = Code 3, Selection 2 = Code 10, etc.

I'm using the HAS() function to do this, and because there are so many options, it's choking our sheets (to the point that they started failing today). Is there another function or way to do this? I've thought about building a reference table to house the Selection and the corresponding code, but that seems like it would be just as tedious for SmartSheets to calculate as what I'm doing.

Any thoughts or help is greatly appreciated.

Miek

Paul Newcome

Are you able to provide a screenshot example of what you are wanting to accomplish?

L_123

could you add a number to the left of the values that sorts it, and use a left(value@row,1)="1"

or something like that?

Or you can use form dependencies in correlation with several columns to separate the data out on the sheet.

Mike Rini

Annotation 2021-02-12 124949.jpg

Sure, I'll just show an example in Excel for reference - it's probably easier anyway. The biggest challenge is the sheer volume of formulas it's trying to process, each submission. I feel like this has to live in a reference table somewhere, but I'm not sure that even solves the problem.