Cell to hold multiple values

Options
Jeremy Oesch
Jeremy Oesch ✭✭
edited 04/05/24 in Formulas and Functions

Hello,

I am trying to create a formula (or if there is a better way please let me know) for a cell to have multiple values if true. So i have one column with a drop down with 10 different options and 10 more columns. If someone picks the first option then they only need to fill out 2/10 columns and if they pick the second option they only need to fill out 3/10. Some of the columns they have to fill might overlap. I basically want a formula/way where I can have one formula cell and it will have the information that they fill out after choosing 1 of the 10 options otherwise there are 20 different columns they have to look at and is not practical. To the same, some of the option might only have a column specifically for that option and will not overlap. Below is a very simple example.

So in a sense I would want a 7th row that would say "1, 2, 3" or "3, 6" or "2, 2, 4, 5" so it is listed out.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!