Using Index Collect formula when there are multiple matches in the source sheet. (#Invalid Value)

edited 05/05/22 in Formulas and Functions


My goal with using INDEX(COLLECT)) was to obtain information based on 3 different criteria, but in my source sheet there are multiple matches for the three criteria specified.

What do I need to add to the Index, Collect formula to overcome this or do I need to use a different formula combination?

Below is the formula:

=INDEX(COLLECT({Reviewer}, {Product}, [Product Name]@row, {Review Type}, [Review Type]@row, {Round}, [Round #]@row), 1)


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!