Join Collect

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

Hi I'm trying to to create a sheet that tells me all of the timekeepers that work on a client from data from another sheet. 

Currently I have sheet that list all of our clients and I will like to add a column that list all of the timekeepers that work on the project. Normally I would use Index Match however, some clients have multiple time and index match only show one timekeeper is there a formula to show multiple timekeepers. 

Here is the index/match formula I use: =INDEX({TimeKeeper}, MATCH([Matter Number]1, {Matter Number}, 0)

In the below example you can see the index match that only shows one name, however for client Red there should be 4 names. Any help would be appreciated.

Data sheet.PNG

data 2.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!