Linking smartsheet

I have a master sheet that I am using to pull in data from the child sheets (linking). The child sheets are dynamic and new parents and childs could be added.

1. When linking i lose child sheet hierarchy on the master sheet. How do i maintain hierarchy?

2. When new tasks are added (with hierarchy) how can i keep the master updated automatically?

3. Can i create hierarchy using a formula?

Thanks in advance.

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi Jamie,

Unfortunately, it's not possible to maintain the hierarchy between sheets and there isn't a formula for hierarchy at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Happy Holidays & Happy New Year!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
Formula for populating date
I am needing a formula that calculates Termination Date (date property). The formula needs to look at Initiation Date (date property) and Term (text/num) which is based on # months, to calculate Termination Date. In this example, the termination date should return a value of 1/01/26. Thank you!
INCORRECT ARGUMENT SET on an =IF function
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…