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
?Bidding for first time? Click here to learn how StartAJob platform works.
?Want to do the job or have questions for the customer? Write then in the " Write a note or message to the customer"
?You already have the estimated cost and time to complete the work yuo are in the fields "Execution time" and "Payment requested" or leave them empty and can be changed later.