How can I display the last value from a column into certain cell?

Felix Schütze

Hi guys,

I would like to display the last value from the column "Project Phase" into a cell (in this case I would like to implement it at the first cell of the column " Project Phase".

Regarding to the screenshot, this would mean that I would like to have the text "Offer Phase" to be displayed automatically in my cell at the top. For this example, you can take the second text "Offer Phase" (Status: not started; Modified: 26/05/21 18:03) as the last value in the column "Project Phase".

I am looking forward to hearing from you!! Thanks a lot in advance! :)

Best regards

Paul Newcome

Try something like this...

=INDEX(CHILDREN(), COUNTIFS(CHILDREN(), @cell <> ""))

Paul Newcome

Are the green rows indented under the blue row so that they are "child" rows?

Felix Schütze

Hi Paul, thanks for the quick answer.

Yes you are right. I totally forgot to mention that there are some parent-child relationsships.

So the green rows are the "childs" from the blue row. And in addition to that, the white rows are the "childs" from the green row, which is above them. And then is goes on with that logic.

Technically, I thought about to solve my problem by implementing the "modified" column. The clue behind it would be, that the value (in the column "Project Phase") with the latest date (in the column "modified") is the value I would like to display in my destination cell at the top. In this case the latest date would be the "26/05/2021 18:03" which means that the value "Offer Phase" should be linked.

Do you think that this idea will work out? Or do you have another way?

Thanks in advance!

Paul Newcome

So are you wanting to just pull the last Child (green) row, or were you wanting to pull the most recently updated Child (green) row?

Felix Schütze

Yes, my inital intention is just to put the last Child (value in a green row) from the column "Project Phase" into my destination cell at the top.

I have just thought about to solve my problem by implementing the "modified" column. Due to the logic of this sheet, the "project phase" value with the latest date (in column "modified") is the value I would like to display at my destination cell.

But in case you have already a solution for my inital intention, this would be amazing!

Paul Newcome

Try something like this...

=INDEX(CHILDREN(), COUNTIFS(CHILDREN(), @cell <> ""))

Felix Schütze

Amazing, it works!

Thanks a lot Paul! :)

Paul Newcome

Happy to help. 👍️