I'm trying to use INDEX/COLLECT to bring back more then one result in the same box


=INDEX(COLLECT({TMPIT}, {TM}, Login@row, {TMPIT}, ="Dock Stocker"), 1)

This works for 1 result.

If a login has more then one result, how do I get those result all in one box?


I want to search the list and see that awhit has all of these machines

I would like the result to be

Also if the login does not have any of these to get the result None


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!