Hi. I need to write a code for Google spreadsheet. I have a spreadsheet with abo

Question

Hi. I need to write a code for Google spreadsheet. I have a spreadsheet with about 30 rows and 3 columns - say A2:C30. Every cell in column A has a name in it. Every cell in column B has a time in it (such as 11:45, 12:30, 13:00, etc). In column C, I want to go through it each day and add a note or a date or a number in there. I want a code that always runs that says that if a cell in column C is blank at the time listed in column B (using the current date), then it sends me an email telling me that there is no value listed for "X" - where the X refers to the name in column A.

Explanation / Answer

THE SOLUTION IS BIG SO I AM HEREBY LISTING YOU SOME WEBSITES THAT WILL HELP YOUIN SOLVING YOUR PROBLEMS. THESE ARE- http://code.google.com/googleapps/appsscript/articles/helpdesk_tutorial.html http://code.google.com/apis/chart/interactive/docs/dev/implementing_data_source.html http://ssisctc.codeplex.com/

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.