Tire Maintenance - Form / Spreadsheet Assistance

edited 12/09/19 in Formulas and Functions

Hello All,

Today is my first day (YAY!). I'm digging Smartsheet thus far, although, I'm looking for suggestions. I've been tasked with creating a Tire Maintenance Program. So far I've put the basic asset information (Year, Make, Model, VIN, Tire Size(s).

Screen shot will help make sense of this. The key part is trying to track which tires are replaced and capture mileage (price and associated PO will be added at a later date) to see what tires we are getting the best value out of. I went with the row indentation thinking this would be accessible via creating a user form, however, I was wrong lol.

Once it is set up, I would like the user to be able to update using a form. There are different tires (Steer, Tag, and Drive) for almost all of our units. 

Any recommendations?



- Rockee

Screen Shot 2018-01-17 at 4.05.45 PM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!