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!
-
Excellent. Happy to help.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives