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
Hi all,
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.
David
Comments
-
Hi all,
I have played a little using this :
=PARENT([Project]102)
But this does not work well in my situation.
If I paset the formula down the entire column it returns blank if the issue is not in a partent/child relationship. For me, it has no advantage over creating the project manually agains each child.
I will report more if I find the answer myself
Thanks
David
-
David,
Does this help take care of the blanks - or at least some of them?
=If(Isblank(PARENT([Project]102)), [Project]102, PARENT([Project]102))
-Brett
-
Thank you so much for this Brett! I've been racking my brain to find a solution. Never would have thought of "Isblank". How would I deal with "grandparents" ?
-
Sorry for the delayed reply.
Yes, Brett's solution tidies up the sheet nicely
Many thanks
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives