Showing Parent Tasks in a Report?
Hello,
I'm building a task report to show all tasks in yellow or red. The issue I'm having is the tasks are named the same across multiple sections of the schedule, for example:
- Developmental Editing
- Task 1
- Task 2
- Task3
- Copy Editing
- Task 1
- Task 2
- Task 3
So my report ends up looking like I have duplicate tasks. Is it possible to include it's immediate parent task in the report as well? Note that these tasks are under several levels of parent tasks so I would like to only highlight their immediate parent. Any help would be appreciated.
Thanks!
Rob
Best Answers
-
I hope you're well and safe!
You can add a so-called helper column with the following formula and include that in the report. (Change the column name to match yours)
=PARENT(ColumnNameWithWhatYouWantToShow@row)
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Excellent!
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
I hope you're well and safe!
You can add a so-called helper column with the following formula and include that in the report. (Change the column name to match yours)
=PARENT(ColumnNameWithWhatYouWantToShow@row)
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hey @Andrée Starå
I'm getting an #UNPARSEABLE result from that formula. The column with the parent task information I want to pull is called "Task Name" so I put in =PARENT(Task Name@row) and it came back unparseable. I also tried =PARENT[Task Name]@row and it came back unparseable as well. I'm putting this formula into a column I've titled "Parent".
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
That worked! Thank you!
-
Excellent!
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I tried this workaround with the formula added to a helper column then included the column as the grouping option in my report. Almost worked. 1: My honest opinion is that we shouldn't have to keep adding helper columns. This is a ridiculous add on to the work. Please make some enhancements to rectify this. 2: My report grouped the parent rows under a "Blank" grouping header rather than with their children or as standalone rows. I already had helper columns identifying parent and children using a COUNT formula to identify Ancestors/Parents =0.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives