Having Indented Children enter and leave Reports with Parent
Good Morning Community,
I use reports to give concentrated views of our Master SmartSheet to Project Managers for ease of use and navigation. One example of such a report is an Overdue Est. Installation Date Report that populates into the report when the Est. Installation Date is in the past. I would like the Parent to bring it's indented children into and out of the report with it when the criteria are met or no longer met. Right now the report will let the Children stay independently as the Parent leaves when the Parent no longer meets the criteria, but the children do. This leaves Children behind that you can not tell what project they belong to. The only thing I can think of is making a helper column that makes sure the parents status for reports always gets transferred to the children. Any thoughts?
Best Answer
-
This: The only thing I can think of is making a helper column that makes sure the parents status for reports always gets transferred to the children.
It's not ideal but until they add hierarchies into reports, this is what's working for me.
Answers
-
This: The only thing I can think of is making a helper column that makes sure the parents status for reports always gets transferred to the children.
It's not ideal but until they add hierarchies into reports, this is what's working for me.
-
Thank You Ryan, that is the way I am going to move forward.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives