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.

SteveW

Looks like this will help with my issue. Unfortunately I am too new to know where to put the formula, can you provide details??

Thank you

Georgie

Hi @SteveW,

I'm sure the Community will be able to help with your question!

Could you create a new question and include screenshots of how your sheet is currently set up, and include more information about what you'd like the formula to do? Please make sure you block out any sensitive data in the screenshots.

Thanks!
Georgie

SteveW

Hi Georgie, It will take me a couple days to emulate what the company is doing but would really appreciate the help! I'll post pics and steps we take to manually update our dashboards.