Subitems "Child Tickets" Automations
Hello,
I recently started a new intake system within Smartsheet for our Training team. The way they structure tickets is unique. They have Parent tickets and Child Tickets. The individual requesting assistance from the training team can submit a ticket, but that ticket could have several deliverables . Each deliverable is broken out into a child ticket. To help structure this correctly in Smartsheet, we have the original ticket (Parent Ticket) as the main row, and all subitems (child tickets) indented underneath. The issues I'm having are around automation. Is there a way for Smartsheet to view all subitems as a child ticket?
A few examples:
- When a Parent ticket is complete, it moves with the subitems to our Archive Sheet. We do not want the subitems moved without the parent row.
- When reporting, can we separate out the child tickets from the parent tickets if they are listed as subitems?
- When a new ticket is submitted, we want to have an automation to send an email so the requestor has a copy of the ticket, but we don't want every single deliverable to be emailed, only the parent row.
Any help or suggestions is greatly appreciated!
Answers
-
I hope you're well and safe!
All you describe is solvable and, of course, in multiple ways. Here are some ideas.
- When a Parent ticket is complete, it moves with the subitems to our Archive Sheet. We do not want the subitems moved without the parent row. [Andrée Starå] We could add a so-called helper column to indicate that it's only parent rows that should move.
- When reporting, can we separate out the child tickets from the parent tickets if they are listed as subitems? [Andrée Starå] Yes, in a similar way as the previous answer.
- When a new ticket is submitted, we want to have an automation to send an email so the requestor has a copy of the ticket, but we don't want every single deliverable to be emailed, only the parent row. [Andrée Starå] We could use the Placeholder feature and include exactly what's needed in an alert.
Would 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, Awesome, 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.
-
Thank you for the response! I've been out of office so just getting to this.
Can you help me with item 1? I'm familiar with helper columns, I'm just not sure what that setup would look like to help indicate the parent rows shouldn't move without the children.
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