This is very usable right away. But I will try to modify for our own purposes so as to provide a digest in a single email of outstanding items at specific times of day (since I will see how it works within the context of a team using a spreadsheet as a task list).
Also this gives me a lot of best practice to learn from wrt preferences handling.
incredible script, but I have onw question. If I need to send the e-mail to another address than mine, what I should change in the code? Is that possible?
This works great for my requirement. I can make it e-mail for dates found on a single column.
But I hope the script is also built to accept dates to be searched in more than 2 columns. What is the syntax that I should fill the "Check dates in column(s)" box if I should make it search for dates in two columns, say B & C. I tried with B:C & B,C, but the box turns Red indicating it is a wrong value. Which is the correct way? It is not discussed in the documentation page.
3 comments :
This is very usable right away. But I will try to modify for our own purposes so as to provide a digest in a single email of outstanding items at specific times of day (since I will see how it works within the context of a team using a spreadsheet as a task list).
Also this gives me a lot of best practice to learn from wrt preferences handling.
Thank you very much Romain as usual. David Tew
Romain;
incredible script, but I have onw question. If I need to send the e-mail to another address than mine, what I should change in the code? Is that possible?
Real thanks for the script anyway
My best wishes
Romain,
This works great for my requirement. I can make it e-mail for dates found on a single column.
But I hope the script is also built to accept dates to be searched in more than 2 columns. What is the syntax that I should fill the "Check dates in column(s)" box if I should make it search for dates in two columns, say B & C. I tried with B:C & B,C, but the box turns Red indicating it is a wrong value. Which is the correct way? It is not discussed in the documentation page.
Post a Comment