I Have a sheet that collects, via form, all the diesel issued to our equipment. I have a column that needs to look at the previous hours for the specific equipment number, but my formula only looks 1 entry back, and should continuously look back. My formula looks like this;

=INDEX(COLLECT([km/Hour]:[km/Hour], [Job #]:[Job #], [Job #]@row), 2)

Please assist



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!