How can I flow cells from one sheet into multiple sheets based on date?

I am familiar with the copy cell automation to a different sheet. However, I am having trouble figuring out how to do this with one sheet>middle man sheet> to end sheet.
The sheet in the beginning will constantly have additions with new dates and I want them to flow into a new middle man sheet (that will be created from a template) every week that will flow into an end sheet/template based on the date (that will also be created from a template).
Answers
-
Hi @hclacken
Every time a new sheet is created, a new mapping will need to be made. There currently isn't a way to designate a workflow to copy/add rows to sheets that don't exist yet, even when they're created from a template.
If you have a minute, please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!
Thanks,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives