Forum Discussion
Excel issue - maint. tracker
Greetings, all. I've been tasked with creating a live service interval tracking formula for our preventative maintenance. This maintenance is tracked by mileage on the vehicle. We would like to ...
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.
