Auto populate a child from a parent

I would like my child row to auto populate from the parent row when triggered from a cad person. I would like the "Drawing Number" and "Project" from the parent row to auto populate the child row when a "Cad person" is chosen. I would be fine with a separate column that would equal the parent row drawing number and Project per child when triggered from a cad person.


Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @MForston

    =IF(AND([Cad Person]@row<>"", COUNT(CHILDREN([Drawing Number]@row))=0), PARENT([Drawing Number]@row)+" "+Project@row)

    If you want additional delimiters, like a dash, in between the Drawing Number and Project then add that between the quotes,

    Will this work for you?

    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!