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).

Tags:

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    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