Returning the last entry in a column?
Hi,
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!
Thanks
Answers

You could insert a "Helper Column" that can be hidden after setup that essentially replicates the row numbers.
=COUNTIFS(Ratio$1:Ratio@row, OR(@cell = "", @cell <> ""))
Then to pull the data you want you can use an INDEX to pull and a MAX/COLLECT to grab the highest row number where Total is not blank and use that for the row number in the INDEX column.
=INDEX(Total:Total, MAX(COLLECT([Row Number]:[Row Number], Total:Total, @cell <> ""))

I've managed to find a sort of solution using the Report function. I created a Row Report, and set one of the columns to show only 'Greater than 0', It filtered out all the blanks leaving just the filled in data.

How are you returning the single line from the report?

I didn't in the end, but It gave me a way to display the filtered data in a graph, which is good enough for what I need at the moment!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 361 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!