Trying to lookup most recent
Hi New to smartsheet
So my goal is to lookup only a value from the most recent row in another sheet and preform a calculation
Example. What I am trying to build is a countdown to Preventive maintenance for some of my fleet vehicles as entered on forms
The idea is when row 1 on this sheet is updated (oil change preformed) the formula on another sheet will only look for data in the most recent row and calculate life remaining
I was able to get it somewhat working by utilizing the "large" lookup from the other sheet but that also changes the historical data. Any help would be appreciated
Help Article Resources
Check out the Formula Handbook template!