JOIN forumla help

Jeana
Jeana ✭✭✭✭✭✭

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!