Getting Value of Last Row
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
Check out the Formula Handbook template!