Closed

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, look new job, spreadsheet script google, spreadsheet script, script sheets, script google spreadsheet, follow job, spreadsheet google, email google doc, google sheet script, google script spreadsheet, google docs status, google docs cost, row spreadsheet, job visual basic, google sheet, google doc, for job, email spreadsheet, create spreadsheet, spreadsheet tracking, spreadsheet sales, time triggered, change google, day sales job

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

Project ID: #2523557

5 freelancers are bidding on average $152 for this job

ambar

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

$250 USD in 7 days
(30 Reviews)
5.9
naveenvarthaan

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)
4.2
arshsoftware

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)
0.0
xflofoxx

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)
0.0
insightrussia

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)
0.0