Index Match or Index Collect with multiple criteria

Shelby ✭✭✭✭✭
edited 11/19/20 in Formulas and Functions

I'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET.

=INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row, {Scope of Work}, [Scope of Work]@row))

Solutions? 😁



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!