Combine (Concatenate) Text or Values from Two or More Cells into Dropdown List Column

Options

Is it possible to Combine (Concatenate) Text or Values from Two or More Cells into Dropdown List Column (allow multiple values per cell) and have it display as separate entries? I am aware of how to combine using spaces, dashes, commas..I just want it to have this view (see picture).


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!