Matching using Multi-select column values

Options

I have the following three columns Idx, Stage and Steps.

Steps is a Dropdown Multi-Select column.

I want to use the step value from column in another sheet to find which row that step belongs to so I can return the Idx or Stage values from a formula.



Stage-Steps.PNG



✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!