Formula to pull most recent update in a row of data

I am tracking the monthly progress of a project, and I would like a formula that can look at a row of cells, determine the most recent update (based on a timestamp, preferably), and then insert that cell of data into a different cell. See image below.
I have seen this done before in other sheets but I cannot figure out the formula for it.
Comments
-
Unfortunately there isn't a way to do this within SS, but it is a great idea. I would suggest submitting an Enhancement Request....
EDIT:
It is possible to do this without a timestamp so long as month 1 is always filled out before month 2, month 2 before month 3, etc without any blanks in between. You could use a basic
=INDEX([Month 1 notes]@row:[Month 5 notes]@row, 1, COUNTIFS([Month 1 notes]@row:[Month 5 notes]@row, ISTEXT(@cell))
This replaces the column number in the INDEX function with the count of how many cells have text in them.
-
-
Thank you - this did work for me!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives