Solved: Automated Report selecting last 3 rows - Page 2

Travis1 · 07-24-2022 12:37 PM

Hi All,

I am working on a automated report that needs to send the last 3 cells of a sheet. I have found a formula with MAXROW that sends the last row, but I cannot find a way to make it do MAXROW (Minus 3).

Can someone help me with this? I feel like this is a simple fix and I'm just too close to the project.

Thank you in advance

Travis1

Okay, my previous solution did not work.

Here is how I solved it:

1. Created a slice with formula: [TIME]=MAX(Notifications[TIME])

2. had a report call the slice, Condition set to: "true"

NOTICE: All of my records have a timestamp on when they are moved from one sheet to another (External tool). By pulling the MAX time, I was able to ensure the most recent time was selected.

Thank you for everyone's help!

View solution in original post