Creating Recurring Tasks in Smartsheet While Retaining Original Rows

System

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

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

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.