Parent row in report
Answers
-
someone can help support... ?
-
I haven't forgotten about you. I'll try to look at your sheets later today/tomorrow.
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.
-
many thanks !
-
I hope you're well and safe!
Excuse the late response.
Crazy times and I missed coming back to you.
Have you solved it, or do you still need help?
Happy New Year & Stay safe!
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 have this same question. I would like to include the parent rows in an "assignee" report even if the parent rows are not assigned to the assignee. Example:
I would like to see these parent rows in the report:
-
Reports evaluate rows on an individual basis, regardless of hierarchy. This means that if your report criteria is not in the Parent row, that row won't appear in the report.
You could potentially adjust your Assigned To column to include multiple contacts, then make sure every Parent includes all of the users assigned in the Child Rows in its cell. That way it would meet your Report criteria.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Andrée Starå , this is an older string, but I would love an update to this follow-up question. I used the helper column formula: =IF(COUNTIF(CHILDREN(Owner@row), "Worker Name") > 0, "Worker Name")
But this only pulls up if the Worker is the ONLY person in the cell. Is there a formula if the Worker is in the cell w/ other names? Is there like a CONTAINS function w/ this same formula?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!