Index, Collect multiple criteria

Melissa Torrez

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

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.