Adding all task participants to parent cell
WHAT I WANT TO DO:
I need to add all participants of tasks to the tasks' parent cell (one time each, in case that's an issue). If there is a way to automate this, I would love to hear it.
That's the long and short of it.
WHY I WANT TO DO THIS:
Why do I want to do this? Well, in an attempt to add parent rows to reports, but only if they have children appearing in the report, I have am doing these things:
Add an "Include Parent?" checkbox column
Add criteria in the formula for the cells in this column: =IF(OR([% Complete]@row < 1, [% Complete]@row = ""), 1, 0)
This formula mimics a criterion in my report.
As the report will only show tasks assigned to the viewer, I need every assignee in the parent's tasks to appear in the parent "Assigned to" cell in order for every viewer to have pertinent context for the tasks they are being asked to update.
This cannot be the best solution, but the other solutions I have read don't seem to take into account whether or not the child is being included in the report.
SS says they have been working on this since before April of 2016, so maybe the solution is already integrated?
Thank you.
Comments
-
Hi Ben,
I might have an idea.
Can you maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!