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 ...
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.
