Automation and parent rows
Can I make an automation where it copies rows from one sheet to go under a certain parent row of another sheet instead of just at the bottom
Best Answers
-
Hi @sipsevents,
I’d recommend moving the rows manually because that would probably be the easiest method.
Another option could be to have different sheet for each section and then collect them all in a report.
What do you think?
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 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: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.
-
Here is some helpful information regarding reports which might be your best method of aggregating the data from each form.
Answers
-
No, unfortunately that sort of activity isn't possible. Have you thought about redesigning the destination sheet with summary data at the top to summarize all the rows pertaining to it? If you put data in the rows being sent that would tie it to a particular summary data row you could in estimation do the same thing as embedding it under a particular row and summarizing the data. Would that work? Do you have samples that you can share? Or specific goals you're trying to accomplish?
-
I don't really understand what you're saying, we just started using this so forgive me. I'm trying to figure out how to take things from a from that i have that's requesting setup and cleanup help for an event, and i was hoping to have them inserted into these blank fields. Any advice is welcome!
-
Hi @sipsevents,
I’d recommend moving the rows manually because that would probably be the easiest method.
Another option could be to have different sheet for each section and then collect them all in a report.
What do you think?
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 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: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.
-
Here is some helpful information regarding reports which might be your best method of aggregating the data from each form.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives