Formula

LJK

Hi everyone,

I have a form going were people add rankings.

I am trying to compare in a seperate sheet the latest two entries. Is there a way that I can tell smartsheets to always pick the lates two entries from another sheet? I know how to pick the latest but I am not sure about how to pick the two most recent ones.

James Keuning

Either use a Row ID which is a number with no prefix, or use a Created Date system field, and then use LARGE. Use LARGE(range,1) and LARGE(range,2).

https://help.smartsheet.com/function/large