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")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome I got this formula to work with 1 criteria but can't figure out how to make it work with the 2nd criteria.
working formula with 1 criteria:
=JOIN(COLLECT({CO's Reoccurring Tasks Range 3}, {CO's Reoccurring Tasks Range 4}, [Day of week]@row), ", ")
Formula not working with 2 criteria:
=JOIN(COLLECT({CO's Reoccurring Tasks Range 3}, {CO's Reoccurring Tasks Range 4}, [Day of week]@row), {2024 CO's Reoccurring Due Dates Range 1}, "Daily", ", ")
Here is my cross reference being used in the 2nd criteria:
-
@Krystal Garcia You just have a misplaced closing parenthesis. The second range/criteria set should go inside of the COLLECT function.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome duh, I knew that. You're the man, thank you!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!