create a google spreadsheet for job tracking

I need a google docs spreadsheet. I have included something I started and how I would like it to look. i need 3 sheets for 3 sales people. There are several features I want included such as: i want a condition where if the follow up date is more than 5 days old it will email that row if possible or the whole doc if need be to the person associated with that sheet as well as myself. also if "status" is on hold, sold, or completed then i do not want that emailed. when the"status" column is set to a selection I want the entire row to change color. I would like the following colors: new=yellow, quoted=orange, follow up =red, on hold = blue, sold=green, and completed=grey. also i would like to know how the info can be triggered. do i have to open the doc each time or can it be set to check the doc each day? Please let me know your thoughts and what the estimated cost and timeframe would be.

Skills: Anything Goes, Excel, Project Management, Script Install, Visual Basic

See more: create google spreadsheet, when to look for a new job, spreadsheet script google, spreadsheet script, script sheets, script google spreadsheet, look for job, how to follow up on a job, google. docs, docs. google, create a spreadsheet, where is google docs, what is google docs, what is a google doc, spreadsheet google, how to google docs, how to email a google doc, Google Sheet Script, google script spreadsheet, google google docs, google docs status, google docs is, google docs how to, google docs cost,

About the Employer:
( 0 reviews ) Manteo, United States

Project ID: #2523557

5 freelancers are bidding on average $152 for this job


Dear Sir/Madam, We have a solution. Please check my private message. Thanks Shome.

$250 USD in 7 days
(30 Reviews)

Hi, I am not able to access the file . It says "You need permission to access this item. You are signed in as , but you don't have permission to access this item. You can request access from the owner or choose a More

$50 USD in 2 days
(13 Reviews)

We can manage to send e-mail either that particular row as well as data to the whole sheet(not sheet as attachment, only data to that sheet) to the specified person. Yes, we can manage to change the color of that row More

$110 USD in 3 days
(0 Reviews)

Good evening sir, I'm from Italy and I'm a senior software developer. I use google docs since the day they start and I can help you with all the things you request. If you like, I want to talk a little about the pr More

$100 USD in 7 days
(0 Reviews)

Main functionality will be done in 4-5 days, i realize the report for your form and this report you can get on emails that you say with periodically what you need. But you must know, that free of charge Google Apps sen More

$250 USD in 5 days
(0 Reviews)