Automated schedule builder
Is there a way to have Google Sheets automatically build a schedule based on responses to a Form? - Google Docs Editors Community
Google Sheets Template Generator - Work back from a specified end date
Need to make a Employe Schedule
What are some alternative work schedules?
What is a rotating scheduling system?
Videos
I’m trying to make a “schedule builder” where there is a list of items that COULD happen in a day. There is a drop down in the column beside to indicate “yes” or “no” if you want this item on the schedule for the day. Is there a way to take this yes/no information and if the answer is YES, it is brought into the schedule on another tab? I know how to use basic formulas and tables but this is out of my repertoire. Thanks!
A few years ago, I shared a Google Sheet that let the user quickly configure a Todoist csv project template and also time shift the dates en masse. I'm not going to go into that again - see this post - but as handy as it was, the fact that its configuration was from a start date limited its usefulness for some.
As time has gone on, there have been a number of posts on here from folk that would, not unreasonably, like to determine a "Go Live," date and work the dates/critical path back from it for the tasks in question. Until now, I've not got around to reconfiguring the template to work in this arguably more useful manner.
So, in this new version, you can now....
Once again quickly configure your template with auto-population of the relevant columns to ensure successful import into Todoist
Specify your project's end date. It will check and alert you if it's not a weekday (this template is working-week focussed)
For each task, specify the number of week days back from the end/go live date it should be completed on
List working dates to exclude, e.g. holidays, from the project's timeline
Optionally add a uniform time to each of the tasks with due dates in your project, to ensure you get notified about each task in Todoist
Full documentation on how to use it can be found within the spreadsheet on the "How to use," tab. You can view the template generator online here or make a copy to add to your own Google Drive and use here. Both the links are also accessible from the Todoist section of my homepage.
If you find this tool to be of use in your work, please feel free to buy me a beverage via the included link. Have fun!