Is there a way to find the last value in a column? Tried Index but did not work



I am trying to get the latest values added in a range to generate the dashboard metrics I need. I am able to return the max values, but the values in one column (Change), may go down or up. I tried using INDEX, but it did not work.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!