Join Collect with Multiple Criterion
Hello,
I'm looking to build a JOIN COLLECT that evaluates by name and date. What I'm hoping to accomplish is you enter a name and a date, and it will pull data from all rows with that name and date into one. I have two sheets, one that all the data is being dumped into (Sheet1) and the second that is organizing it (Sheet2). Any help on how to write the JOIN COLLECT formula, would be super appreciated!
Sheet1
Sheet2
Answers
-
Try something along the lines of
=JOIN(COLLECT({Range To Join}, {1st Criteria Range}, 1st criteria, {2nd Criteria Range}, 2nd criteria), "delimiter of choice")
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!