Index Collect Contains Formula


Hi, I'm trying to report data in one cell if data in another cells contains a partial phrase listed in a third cell. Here's what I've got:

=INDEX(COLLECT({WE Org Owner}, {Pilot/PM}, CONTAINS([Primary Column]@row, @cell)))

It's giving me #incorrect argument. The reason I need a Contains is because the primary column is referencing someone's name, but in Pilot/PM he's listed as Person 1/Person 2. If Person 1 appears in Pilot/PM, I want it to report out the data from WE Org Owner for that row.

What am I missing?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!