We are looking for someone who can work with a couple of google sheets and create custom reports.
What we have:
- Google sheet data updated by 6-10 people everyday using Google Forms. It has details about the employee email id, projects(using drop down) they have worked and number of hours they spent on that project that day.
- Same google sheet data as above filled using same google forms as above by same employees - but they also use it to mark their login time and logout time
- A separate google sheet where we enter Per hour cost of each employee - along with their email id.
Reports we want:
- Use data from google form linked google sheet.
- Add some filters (from date, to date), Project drop down, Employee drop down (multi select)
- Calculate the costs per project (with all employees) or calculate the cost per project basis on the selected employees)
- ANOTHER REPORT for attendance - Consolidate login and logout time and show that in one row, calculate the time spent in hours each day, and calculate the total working days between a date range (from date, to date)
- Automated triggers
---Trigger an email if the employee login is not logged-in for any weekday (monday to friday) by 11am.
--- Trigger an email if the employee login is not Logged-out for any weekday (monday to friday) by 9 pm - no email trigger if the log-in was not marked for that day.
Please let me know your experience with google sheets and custom reporting so it helps me shortlist.
24 freelancer chào giá trung bình$134 cho công việc này
I have read your project description and think I can help. Let’s chat in more detail about your project needs. Waiting for your good response. Let me know the more details the project.®