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.
Comments
-
You can use that date in an INDEX/MATCH statement something like this...
=INDEX(CHILDREN(), MATCH(date formula, CHILDREN([Date Column]@row), 0))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!