Formula to pull most recent update in a row of data

ELaliberte

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.

Paul Newcome

Unfortunately there isn't a way to do this within SS, but it is a great idea. I would suggest submitting an Enhancement Request....

 

https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?_ga=2.159640381.1007642702.1547469573-1191285599.1543241172

 

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.

Paul Newcome

ELaliberte

 

Please see edit above.

ELaliberte

Thank you - this did work for me!

Paul Newcome

Excellent. Happy to help.