Mileage reimbursement Help


I have automated an expense report. This worked great as I did an index/match on the date the expense was for, compared to the year, and reported back the mileage reimbursement rate.

=IF(ISBLANK(Miles@row), Miles@row * 0, Miles@row * (INDEX({Mileage Reimbursement master Range 1}, MATCH([F*Year]@row, {Mileage Reimbursement master Range 2}, 0))))

The core sheet looked like the below (minus the start and end, that i just added)

My goal is to get something that looks at the expense sheet of DATE, if date is between the start and end date, it will pull back the rate into the calculation.

I'm just not sure how to do a formula without nested if statements.

Can anyone help out?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!