Join a Parent Name with a Child

Hello Smartsheet Guru's

I have a primary column with Story (Parent) and Tasks (Child)

Another Column has Story # - pre-assigned from a vendor.

I want to be able to append a unique number to the task # with the Story Number.

So layout

Primary Column

Story 1

Task 1

Task 2

Second column Story #


Third Column - I would like to append ABC-1 to a unique number - I have a row # column already and would look up the number in the row # column for the uniqueness for the task #.



Sheet Layout

thank you in advance

Bruce Johnson

Director Portfolio, Project Methods & Governance

Veolia North America

Boston, MA

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!