Forum Discussion
Excel issue - maint. tracker
Another question - Is there a way to create the spreadsheet to have the built in formulas where the service is sporadic like this?
Or will the formula need to be updated after each service?
Yes. It's do-able. Would just need to know your logic for how many blank rows should go between entries. Is it a fixed amount or does it changed based on a criteria?
Patrick2788 Hi, it changes based on the vehicle service for that month. So, some many go only days with some go months between mileage maintenance.
Here is an example of what we see -
https://docs.google.com/spreadsheets/d/1zBv3sKpdfBgxWvrZDMSX07Tc5eYiNDxAlVnfn54O7yE/edit?usp=sharing
See the attached version. I hope it does what you want.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar Hi, I have attached a link to the google doc below that encompasses similar data that we will find with the fleet maintenance. I am sure there is a way to do it, but with the data so sporadic across dates, I wasn't sure the best way to have it easily manageable for staff.
Additionally, the spreadsheet can have a "different look", as long as it is operable for the data.
https://docs.google.com/spreadsheets/d/1zBv3sKpdfBgxWvrZDMSX07Tc5eYiNDxAlVnfn54O7yE/edit?usp=sharing
Thank you so much for your help!
