In Google Spreadsheets (NOT the new beta that's available) I need to have reminder emails sent when a date is reached that's in a column.
There is a script available in the Script Gallery called "Add Reminder", but this script is too limited. I need to have at 'least' one reminder per tab (sheet) and in some cases, more than one (meaning, for dates in two separate columns).
The "Add Reminder" script I mentioned is great, but just lacks this expanded functionality.
I have no experience with writing these scripts and really don't have time to learn. Is there anything out there that's already be written which can do this? Or could someone help me get this set up?
I'd also like to be able to change the color of an 'entire row' -automatically triggered by a cell's content. I already used the conditional formatting to try to do this, but it can only change the color of the single cell, not the entire row.
I posted this same issue on stackoverflow and got a response with some examples, but I don't know how to implement them - http://stackoverflow.com/questions/22159491/conditional-formatting-google-spreadsheets/22183928?noredirect=1#comment33680542_22183928
Thanks in advance!