Send Reminders from a To Do List in Google Spreadsheet
I'm working with a team of 7 people and we are using a google spreadsheet to track our team "to do" list.
I have one column that shows who the task is assigned to, the task, and then another column that has the date for when the task is due.
At the minimum, I would love a script that could email "John Smith" a day before the task is due as a reminder.
Here is an example of something similar I found: http://www.gadgetsappshacks.com/20
If you can think of other scripts that would make the to do list even better, I am open to hearing them.