I need a spreadsheet that tracks hours spent on individual projects (we are consultant surveyors / loss adjusters) and each, individual job sheet populates a master sheet. The individual job sheet that we use is attached. I need to be able to see all 'active' cases. Once completed they need to move from the 'active' sheet to the 'completed' sheet and then to the 'invoiced' sheet and then the 'paid' sheet. I need to be able to see all of an individual surveyor's active cases and see the total hours billed at any given time. If possible I need an alert that prompts (email maybe) a surveyor if a case has been 'inactive' for 7 days or more. (I want to ensure that clients are updated). I'd like it to be accessible remotely from home PC's or maybe even phones through the website or similar. Would welcome suggestions. Thanks
412 day(s) 22h 51m
One time job
00:00 - 08:00
Days per week:
To apply for this job you must first login/signup.
click here to learn How It Works
Write then in the "Write a note or message to the customer"
You already have the estimated cost and time to complete the work you are in the fields "Execution time" and "Payment requested" or leave them empty and can be changed later.
If you can get the job done, place your offer in the form bellow or if you have additional questions, you can write them in your remarks field and leave the “desired salary” and “completed within” fields empty. They could be set later.