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
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!
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.
Here is some helpful information regarding reports which might be your best method of aggregating the data from each form.
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!
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello Smart-Heads! This one might sound trivial, but I am looking for an automation to copy limited amount of information from one row to a new row in the same sheet. The sheet contains initial generic information. Column E can be duplicated across the sheet with unique values from column F, assigned to column E, example:…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.