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

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


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!