when I am using a check box and automation to copy rows to another sheet I am only able to take the child rows is there any way parent will also go with child?
Unfortunately, it's not possible now to automatically include the parent row, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As a possible workaround, you could add a so-called helper column that could for example check the box on the parent and include it in the copy.
Would that work?
I hope that helps!
Be safe and have a fantastic weekend!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Can you just provide a little guidance on that helper row?
Did you solve it or do you still need help?
@Rakesh Sethy I just created an automation with parent rows and I clicked the checkbox next to the parent row only and all rows (parent and children) moved to the sheet per my automation criteria.
Hope this helps
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs. This creates…
Is it possible to format a singular cell in a sheet to total the above numbers add in each cell of the column.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.