Return Most Recent Date and Other Column Value or Only Flow Most Recent Entry into Sheet per Account

I need to be able to return the most recent value for the Created Date column and the corresponding Discussed column text.

Currently, I am using an IF, COUNT, MAX, CHILDREN formula that I found on the community to return a MAX date within a grouping of rows but I can't figure out how to also return the Discussed value that corresponds with that row. That will work, but I am also almost at the maximum rows for this sheet and data flows in daily..

So ideally...

What I'd like to do is be able to only have one entry per Account, the most recent entry, in this sheet but I can't figure out filtering to be able to do so. These are records flowing in from Salesforce. Even if there was a way to flow only the most recent records, 1 per account, into a report that would work.

Screen Shot 2019-11-14 at 12.15.16 PM.png

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You can use that date in an INDEX/MATCH statement something like this...

     

    =INDEX(CHILDREN(), MATCH(date formula, CHILDREN([Date Column]@row), 0))

    thinkspi.com