awesome thanks for the info!
I think I changed my mind and want to track more stuff. so I should unhide columns B and C?
Honestly, I think you can fill in the form one more time with the correct options. I do not think this actually works for more than one replacement, though. It should take your existing sheet, rename it to username_old, hide it, and create a new sheet with the new options.
why do Columns E and F both say "Total Miles"?
That is only for your specific instance. F will always say miles, but E changes based on units of measurement one selects. F is used for all calculations that go back to the summary sheet, and instead of doing the calculation in the background, that column handles the conversion from kilometers. In theory, you should only see one of those visible by default, based on the selections you've made.
Also, as this is the first time looking at the spreadsheet I have a unique perspective to help clear up non-immediately obvious things... My only suggestion would be to maybe color the cells with calculations in light grey so it's more obvious where the input is needed (and maybe highlight the cells or columns that require input in a different color, or just leave white).
That's not a bad idea, but may require a bit more work to implement. Right now, if it's a blank box, you can input. If there is a value (even if it's 0) already populated, it's a formula.