Hi! I am creating a report of tasks that are in various stages, and some of the tasks have a parent/child relationship. I already tried the 'Helper column' to identify parent tasks. Is there a formula to use to identify child tasks? Also - Is there a formula I could use where instead of just listing the Parent Task Name in…
We have one master sheet where all of our tasks reside. We use Dynamic view for each tech to review, mange their tasks. However, our Techs would like to organize their tasks in a Heirarchy format. Dynamic View limits that ability. It also limits their ability use the Card view. I set up a heirachy column and conditional…
I have a SmartSheet that I'm using to track my project manager's construction projects they are assigned to. We have some projects for which there are smaller phases that are broken out that I have shown as individual rows set up as child-parent. With dependencies enabled SmartSheet calculates the overall dates of the…
hi Team, New user here on SS. I am wanting to develop a sheet with a gantt chart for my teams leave. It would have categories of the team name and second level category of their names. I was hoping when they add a row for planned leave, it will show in the parent of their name, followed by the parent of the team name. This…
I have a sheet I am using to obtain approvals from both the resource as well as the manager for expected time that the resource will be needed for a project (see below.) Is there a way to do this with the automation? Parent & Child Row: Automation: I have tried using the Message Includes "Includes all fields" as well and…
I am trying to set a filter (to weed out a large amount of rows); the Parent row has several "Children" (see below); however, each time I do it, it doesn't work; it will show the Parent row; however, it will not show the Children below. The Children only have a small amount of data. I am invoicing to the "blue" total…
