JOIN forumla help

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


  • Jeana
    Jeana ✭✭✭✭✭✭

    Good idea! Don't know why I keep over thinking these formulas. :-)



  • Genevieve P.
    Genevieve P. Employee Admin

    Haha no problem! I do that all the time, too. 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!