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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives