Create an automation to move dynamically copy a row to a new sheet
Hi,
So I am currently working on the system where I can dynamically copy aggregation of some data from master database to another sheet.
- We set up a master database on project level to collect data from form submission, this sheet contains all data from all projects for every quarter. The projects delivered by two delivery agencies, so we set up filter sheets based on delivery agency as well
- We wanted to set up a delivery agency based sheets which aggregate some data from the master data sheets that automatically add new new row/submission for each quarter. This sheet will also have extra columns to allow delivery agencies assessment via dynamic view.
- The third sheet will be a program level sheet which pretty much similar with the second sheet but aggregate all projects from all delivery agency.
At the moment I create 2 metric sheets for each level of assessment, the first sheet will record a date for each reporting quarter and copy the row to another metric sheet that link to dynamic view.
Is there easier way to do it?
Answers
-
I hope you're well and safe!
That's probably a similar structure that I would use without knowing all the details.
Have you explored using WorkApps?
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
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 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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!