Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to have child rows displayed using parent data
I have a complex sheet which is efectively a "to do" list.
Thanks to the community I have it working pretty well as I want and am very happy with it.
To polish the sheet, I would like to achieve the following:
I have my todo's organised by project then category. For example, I have a column called "project" which is a dropdown list of all my projects. Then I have various parents "issues" which have child categories.
Obviously, the parent (issues) has must align to a project and logically (to me) all childs (issues) must have the same project as the parent. I currently get round my problem by manually allocating the project to all childs. Basically I do this so that when I filter I can see all issues associated with a selected project, both parents and childs.
In my opinion, this makes for a messy spreadsheet.
Is it possible (I am sure it is but lack the knowledge to implement) to have all childs inherit the project associated with the parent?
Or, to put it another way, I want to filter based on Project and have it show all parents and their associated childs?
Thanks in advance.