Join Collect

Karrie Davis
Karrie Davis Overachievers Alumni
edited 12/09/19 in Formulas and Functions

Hi i'm trying to find all of the timekeepers that worked for a specific client. 


Normally I would use Index Match however,  there are multiple time keepers that worked for the client and index match only shows one name.

For Index match I use the following formula: =INDEX({TimeKeeper}, MATCH([Matter Number]1, {Matter Number}, 0))


I tried Join collect but I keep getting a blank square could some assist.  

=JOIN(COLLECT({TimeKeeper}, {Matter Number}, [Matter Number]1))



Data sheet_0.PNG

data 2_0.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!