JOIN forumla help
Here is a pic of my sheet. I'm trying to find a way to identify a specific CHILDREN row. I thought that using JOIN to bring together the columns that are unique would give me something to refer to to identify a specific CHILDREN row. I'm trying to JOIN the PL##### with the GRANDCHILD under Deliverable Name and Assets. The result I'm looking for is:
PL25148,Request Received and PL25148,Copyediting
However, my JOIN formula isn't working. Any thoughts?
Best Answer
-
Hi Jeana,
Instead of using JOIN, try just adding the cells together, with a comma between:
=PARENT([Asset #]@row) + " , " + [Deliverable Name and Assets]@row
If there is no parent it could look a little funny as the comma will start the cell, so we could add an IF statement around for if the Parent isn't blank. Let me know if you want help with this, or if the above formula works for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hi Jeana,
Instead of using JOIN, try just adding the cells together, with a comma between:
=PARENT([Asset #]@row) + " , " + [Deliverable Name and Assets]@row
If there is no parent it could look a little funny as the comma will start the cell, so we could add an IF statement around for if the Parent isn't blank. Let me know if you want help with this, or if the above formula works for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Good idea! Don't know why I keep over thinking these formulas. :-)
Thanks!
Jeana
-
Haha no problem! I do that all the time, too. 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!