Index, Collect multiple criteria

I am trying to index, collect the approver name from a matrix of approvers by business role.

The formula works if only one business role approval type is displayed, however I need to be able to assign an approval/ sign-off name for all business role approval types selected

=IFERROR(INDEX(COLLECT({BRD approver name}, {Business Requirements Approver Matrix Range 1}, [Business Role Approval Type]@row), 1), "No Result")


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    To pull multiple names you will need to use a JOIN/COLLECT, but...

    We currently cannot populate multiple useable contacts in a cell even if the column is set to allow multiple contacts. Pulling one via formula is fine, but pulling ore than one converts everything into a text string that isn't counted as a contact or multiple contacts.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!