Find Jobs
Hire Freelancers

Custom Google Docs scripting / programming

$30-750 USD

Completed
Posted over 11 years ago

$30-750 USD

Paid on delivery
We currently use Google Spreadsheets for our project management. Our needs are very basic and this has been the only thing that has "stuck" as far as being simple enough to use. We have a template spreadsheet that we save a copy of for every new project, and rename to reflect the project name. It contains 8 tabs for the various things we need. At times we will add tabs if needed per project. Two of the tabs are punchlists (to-do lists) with a simple drop-down color-coded status field (Open, Waiting, To Test, and Re-opened), as well as a drop-down "assigned to" field. There is also a "due date" field. Because this system spreads out punchlists out among separate spreadsheets, it makes tracking and following up extremely prone to human error. Therefore I am looking to add a few bits of functionality: 1) When a task is assigned (or reassigned) to a tech, he is notified via email. This email should contain enough data that he knows: what project it's in relation to (spreadsheet name would be fine), the body of the assigned task, and the due date, if any. 1a) If possible, a daily digest of open tasks emailed to an individual tech. This is optional and may not be needed, but it might be helpful. 2) A master spreadsheet, landing page, or whatever works, for the following functionality: Techs can go to their own page/spreadsheet and see ALL their tasks, regardless of status. They should be able to see Status, Due Date, Task or Client (again spreadsheet name would be fine, but we could also add a tab that has client info or whatever might be needed to help execute this). A master sheet with ALL tasks (except completed) pulled from all of the spreadsheets, including all off the data above and to whom the task is assigned. This spreadsheet should be sortable by any of the fields. It could also have tabs that break it down by client, assigned tech, etc. though this isn't strictly necessary. Because we won't have anything in this spreadsheet that isn't open access to anyone else in the company, both of the above spreadsheets could be one in the same if that would work better. In other words, we'd have an ALL tab, then separate tabs for each assignee. I've tried to be as thorough as possible here, but I am sure there are some more details to work out. Thanks.
Project ID: 2594886

About the project

4 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Can you provide the template spreadsheet? more questions in pmb
$500 USD in 10 days
4.8 (2 reviews)
2.8
2.8
4 freelancers are bidding on average $563 USD for this job
User Avatar
Please have a look at my demos enclosed.
$400 USD in 10 days
5.0 (5 reviews)
3.3
3.3
User Avatar
Hello, i can do this in a timely, accurate and professional manner look to work with you At your disposal for any query. Regards softwarevamp
$600 USD in 14 days
5.0 (2 reviews)
2.1
2.1
User Avatar
Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o
$750 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
North Hollywood, United States
0.0
0
Payment method verified
Member since Oct 24, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.