Consumption Rate calculation

Good day. I have a sheet that is populated by a form for all our machines (100+) that pour diesel. The Job # (machine ID), hours on the clock, litres poured and the issuing date is captured. How do I by means of a formula create the consumption per machine? THe sheet should check the last time the machine was used with that hours as the previous hours, but I am struggling to get it right.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!