Looking for a way to show the last 5 entries in a report

Joanna Collins

I would like to build a report that would show only the last 5 entries (by date/time) in the report. It looks like MAX/COLLECT will only give me the last entry. Is there another way to accomplish this? I added an auto number row thinking maybe I could take the top 5 numbers, but not having much luck figuring it out. Thanks!

Joanna Collins

Found a thread on here using RANKQ and it worked great! Can't find the original poster now to give them credit, but thanks Smartsheet Community! You guys are great!

=IF(RANKEQ([Row ID]@row, [Row ID]:[Row ID]) <= 5, 1, 0)

Checks (stars) the top 5 from my auto number column.

Joanna Collins

Found a thread on here using RANKQ and it worked great! Can't find the original poster now to give them credit, but thanks Smartsheet Community! You guys are great!

=IF(RANKEQ([Row ID]@row, [Row ID]:[Row ID]) <= 5, 1, 0)

Checks (stars) the top 5 from my auto number column.