Formula to pull most recent update in a row of data

ELaliberte · 01/18/19

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.

Capture.3.PNG

Paul Newcome · 01/18/19

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 · 01/22/19

ELaliberte

Please see edit above.

ELaliberte · 01/22/19

Thank you - this did work for me!

Paul Newcome · 01/22/19

Excellent. Happy to help.

Formula to pull most recent update in a row of data

Comments

Categories