join collect several variables
From a metrics sheet I am looking at another sheet with a formula which gathers the docket number if the date is before today and it returns the result perfectly. 12234, 67899, 98765
=JOIN(COLLECT({Docket}, {DueDate}, <TODAY()), ", ")
I am trying to modify this formula to return 2 variables (docket + Client) when date is before today but cant figure it out. looking for 12234_honda, 34567_Acme, 56789_Ford
=JOIN(COLLECT({Docket},{Client}, {DueDate}, <TODAY()), ", ") or
=JOIN(COLLECT({Docket}+{Client}, {DueDate}, <TODAY()), ", ")
Best Answer
-
Fortunately this can be converted to a column formula, so really you should just have to create the column, enter the formula once, then convert to a column formula and move on to the next sheet.
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!
Answers
-
You would need to create the base text strings on the source sheet in a new column.
=Docket@row + "_" + Client@row
Then you can reference this new column on the source sheet in your JOIN/COLLECT.
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!
-
Thanks Paul, dang, i was trying to avoid this as there are a multitude of trackers that I pull from. I will proceed with this method instead. Thanks for your help on this.
-
Fortunately this can be converted to a column formula, so really you should just have to create the column, enter the formula once, then convert to a column formula and move on to the next sheet.
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
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!