User Profile
Aspen_Robert
Copper Contributor
Joined Aug 29, 2023
User Widgets
Recent Discussions
Re: Excel issue - maint. tracker
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=sharingRe: Excel issue - maint. tracker
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!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 know when the vehicle has been properly serviced within its parameters. For example - Current Mileage - 230,000 Serviced Mileage - 234,000 This would be serviced within good standing because it is within the 4,500-5,500-mile buffer (from last service). Currently, I have created this formula - =IF((C8-C7>4500-5500),"GOOD","BAD") I know there is a better way to develop with conditional formulas. Can you walk me through this? I would greatly appreciate any help!
