Weekly tasks automation on task management

Natasha Szczerb

Hello, I'm optimising a task management sheet with automation and would like to know if there's a way to use automation to create a row? Some tasks are weekly, and it'd be great if they could be automatically added in every week, so the owner can get notified and mark them as completed each week. Is this possible?

Andrée Starå

@Natasha Szczerb

Excellent!

You're more than welcome!

Have a fantastic weekend!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Natasha,

You could maybe use the method described in my post here:

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Make sense?

Would that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Natasha Szczerb

Thanks Andree!

That's very helpful! I've added the tasks to another column and did 'copy row' with a date trigger. I don't know how to auto populate the rows in the new sheet yet, but will look into your suggestion.

Have a great weekend!

Andrée Starå

@Natasha Szczerb

Excellent!

You're more than welcome!

Have a fantastic weekend!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!