Matching Neighbor Cells or Rows to Most Recent Date
Hey All,
Background: Im trying to build a fluid dashboard that tracks information coming in from a form. This form is then routed to several sheets where I break it down further based on certain criteria. I am looking for a way to report on the most recent metrics in the given sheet using the sheet summary feature to make it easy to find and add to a dashboard.
Problem: I need a formula that reports on only the most recent row that has been added to the sheet. I think i can do this by some mixture of index and collect but I'm not sure. Could anyone help out with a formula that would return the matched value with the most recent date in the sheet for the columns "Scouting Health and "Field Rating" please? Is there a way to pull in that info with the date it corresponds too (in this case maybe using max([date]:[date]).I would like to keep them as symbols if possible. First picture is the max formula im using to get the most recent scouting date. Thanks so much!
Best Answer
-
You could use an INDEX/MATCH based on the date.
=INDEX([Column Name]:[Column Name], MATCH(MAX([Date Scouted]:[Date Scouted]), [Date Scouted]:[Date Scouted], 0))
Answers
-
You could use an INDEX/MATCH based on the date.
=INDEX([Column Name]:[Column Name], MATCH(MAX([Date Scouted]:[Date Scouted]), [Date Scouted]:[Date Scouted], 0))
-
Thanks so much @Paul Newcome I knew I was missing something!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!