We are still in the trial period and running in to issues. I have created a Time Tracker sheet for each client. Columns are: Client (primary), Employee/Contractor, Project/Event, Date Worked, Time Worked, Task Performed, Charge Description/Code, Project ID, Billable? (check box).
I need to generate a report from this sheet that will be updated whenever we view it, this report will also be shared with our clients so they can review progress and billed hours.
The report needs to have totals of:Sum of non billed hours (based on checkbox not checked); Sum of billed hours (based on check box checked); overall budget total, hourly bill rate, $'s used based on billed hours * bill rate; remaining budget $'s.
Very basic and simple in Excel, seems to be a pain in SS.
One other issue in SS, creating a report from this tracker: When I select the Billable? column for the report, it will not allow both checked and unchecked. It's one or the other, not both.
How do I get a report created from this time tracker sheet that is; 1) showing complete data from the sheet; 2) allows for the tallying we require for clients to see; 3) updates automatically when the time tracker is updated?
