Getting Value of Last Row

handmadetsunami ✭✭✭✭
edited 12/09/19 in Formulas and Functions



I have a smartsheet to track staff working hours and how much time they are up/down based on their contracted hours. I want to be able to get the data in the Minutes Credit/Debit column for the last row (circled in red). The sheet will be added to using a form. 

I want to be able to pull the number out to put on a dashboard to show the teams current credit/debit on contracted hours.

Is there a way to do this? I don't mind adding columns if I need to as I have a load of hidden helper columns anyway




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!