Logical Time Sheet - Google Sheets
Budget: $50 – $0 AUD
We have an existing single excel document with cell conditioning and cell data value constraints and a macro we would like converted to a google sheet.
We own this document and have full rights and knowledge of its requirements.
The macro was used for generating a multiple cell derived filename only when saving.
Our field technicians use this document when they are working on a field job.
We currently need to use a full Microsoft Office Excel version for the macro and we would like to have our technicians use their smartphones instead of a laptop.
We need a similar filename saving function in Google Sheets each time as well as a reset button for the sheet so it is restored and ready for the next job.
We have 3 pages, 2 of which are hidden from field staff until unhidden by office staff - page 2 includes a supervisor check list - page 3 includes page 1 and page 2 data transposed to a different order for accounts processing.
It does some time calculations to convert time into a percentage of hours and has checkboxes and drop down lists.
Hoping someone can assist.
We own this document and have full rights and knowledge of its requirements.
The macro was used for generating a multiple cell derived filename only when saving.
Our field technicians use this document when they are working on a field job.
We currently need to use a full Microsoft Office Excel version for the macro and we would like to have our technicians use their smartphones instead of a laptop.
We need a similar filename saving function in Google Sheets each time as well as a reset button for the sheet so it is restored and ready for the next job.
We have 3 pages, 2 of which are hidden from field staff until unhidden by office staff - page 2 includes a supervisor check list - page 3 includes page 1 and page 2 data transposed to a different order for accounts processing.
It does some time calculations to convert time into a percentage of hours and has checkboxes and drop down lists.
Hoping someone can assist.