Getting information from the latest line entry based on date

Graham Rimell
Graham Rimell ✭✭
edited 12/09/19 in Formulas and Functions



I'm setting up a page where you enter 5S audit test data from a Form. It puts a new row in every time with the 5 different 5S scores each in it's own column. We need to find a way to pull the data from the most recent new row.

I need a way of identifying the row with the most recent date and then moving across X many rows to pull the score from the correct column. 

It seems like I need to use the MAX function and maybe VLOOKUP, but I've had no luck getting anything to work.

Can anyone point me in the right direction?







Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!