Join a Parent Name with a Child

Bruce Johnson

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 #

ABC-1

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 #.

ABC-1-001

ABC-1-002

Sheet Layout

thank you in advance

Mark Cronk

Hi @Bruce Johnson,

Please take a look at this post. I think it will solve your problem. In the post, Paul Newcome provides a link to an example sheet, also below. Good luck.

Mark

https://community.smartsheet.com/discussion/64903/parent-child-numbering

Example Sheet:

https://app.smartsheet.com/b/publish?EQBCT=8ad5c787a43d481ca95b058f3a067782&_ga=2.59965997.1025890723.1606947288-217988497.1602612533.

Bruce Johnson

This is awesome! You folks amaze me! Thank you so much!

Mark Cronk

Hi @Bruce Johnson,

Please take a look at this post. I think it will solve your problem. In the post, Paul Newcome provides a link to an example sheet, also below. Good luck.

Mark

https://community.smartsheet.com/discussion/64903/parent-child-numbering

Example Sheet:

https://app.smartsheet.com/b/publish?EQBCT=8ad5c787a43d481ca95b058f3a067782&_ga=2.59965997.1025890723.1606947288-217988497.1602612533.

Bruce Johnson

This is awesome! You folks amaze me! Thank you so much!

Mark Cronk

Happy to help. Be well.

Mark