Calendar Query - repeating item automation

Yvonne.Clavin

Hi there

Im creating a calendar for my team in SS - some items are repeating Weekly / Monthly / 1st Wednesday etc. How do I automate that rather than having to type each entry individually ?

Thanks for your bright ideas 🌟

Andrée Starå

https://community.smartsheet.com/discussion/139112/calendar-query-repeating-item-automation

Hi,

I hope you're well and safe!

There are multiple ways.

1️⃣ Dropdown that indicates the recurrence, and then use formulas or workflows to populate the correct date.

2️⃣ Helper sheets that are set up with the different options and workflows that copy them over to the main sheet according to the recurrence.

Would any of those options work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

kowal

Hi @Yvonne.Clavin,

What about having one sheet with tasks (main one) and copy those rows to different sheets? You can setup the workflow to copy the specific row every week to another sheet… also on daily basis, and monthly basis. In the destination sheets those will be automatically added instead of being added manually.