Creating Recurring Tasks in Smartsheet While Retaining Original Rows

This discussion was created from comments split from: What is your method for creating recurring tasks?.

Answers

  • mballe
    mballe ✭✭

    How would one create recurring tasks that simply copy the rows once a week/month to the existing sheet, but LEAVE the original row (notes are attached) so that it could be viewed in calendar view?

  • Rich Coles
    Rich Coles ✭✭✭✭✭

    Have a feeder sheet with the tasks you want created each week / month and then have an automation that copies them to the sheet where you want them. Automation can be set to run at the frequency you want and you can have a date formula in the feeder sheet running off TODAY(), which means the date can acts as the trigger and is the intended date when it hits the receiving sheet as only the data and not the formula are copied across.

    Rich Coles

    Prodactive | Smartsheet-aligned Platinum partners

    Check out our Smartsheet-dedicated YouTube channel for tips, tricks and inspiration