Rolling Automated Task Tracker for Google Sheets

[@Ramsousa]

Good job 2 years ago I built a file very similar to yours. Mine is to control promotional campaigns, when they start and end, control the result, who is responsible for each campaign, etc.

[@sheetsbyolan]

Nice! Love a useful spreadsheet

[@AmbrosiabyLZ]

This is awesome. I successfully created the sheet and will try it out in the next month.

[@sheetsbyolan]

Amazing! I hope you like it!

[@TilakConrad]

superb - very nicely done - congratulations and thanks very much - all the best with your channel

[@sheetsbyolan]

@@TilakConrad thanks! So glad you’re finding my content helpful 😁

[@maattsu-k6y]

This is great! Do you have a tutorial where you explain how to code in Apps Script?

[@sheetsbyolan]

I don't since I'm still learning myself. I usually as AI for the code then I know enough to adjust it to match my spreadsheet if needed. Once I master it I'll make a video though!

[@maattsu-k6y]

@@sheetsbyolan I see. Thank you so much!

[@incboti7214]

Whenever i move something to "Ready" it vanishes in the to abyss and i cannot find them.

[@sheetsbyolan]

It goes to the next empty row in your task list so if there’s a formula or a rogue text somewhere in your task list it may skip to a random row. If that doesn’t work, email me. [e-mail]

[@KelliPowers-u4r]

AMAZING! Can you share with me the app script for "quarterly" tasks?

[@sheetsbyolan]

@@KelliPowers-u4r there are no trigger options for quarterly unfortunately. I recommend setting it up with the monthly trigger and if you don’t need them this month you can just delete them from your list

[@RicCharlesJordan]

This is beyond! The continuous workflow helped me stay focused and this just really levels it up! Just wanted to ask, do you happen to know why timestamps are not appearing once I change tasks to Pending it also does not transfer to the Done tab. Thanks, Olan!

[@sheetsbyolan]

@@RicCharlesJordan sounds like you need to reauthorize the apps script to run with the new file. Check out my recurring trigger video. You’ll need to set that up anyways and it’ll walk you through authorizing the script