Contains feature

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.


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You cannot use a formula to populate multiple useable contacts in a single cell. It will display the names as a text string, but won't be recognized as individual contacts by things such as automations or items being filtered by "current user".


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!