Contains feature

Options

I need assistance with a formula.


In my master sheet, I have a Contact column, where the formula lives. Here is the formula I have at the moment, which does work as it takes the value of the Workstream column over to a secondary sheet where I match the Workstream in order to get the appropriate Contact. =IFERROR(INDEX({Contact}, MATCH(Workstream@row, {Workstream}, 0)), "")


In a secondary sheet, I have columns for Workstream and Contact. This allows me to add Workstreams and their appropriate Owner.


My issue is, the business now wants to make the Workstream column multiple select. With that, there might be 1, 2, 3, 4, etc. Workstreams, therefore, the formula should go get all appropriate Owners.


Thoughts?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!