Returning the last entry in a column?



I'm looking for a way to return the bottom row of column that is not the same level as the other columns.

I want to return the ones highlighted in red in another box, however because there is blank spaces between them and the bottom of the other columns I'm struggling to get a formula that works.

It seems like it should be simple to do!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!