Getting Value of Last Row

handmadetsunami

Hi,

 

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

 

Andrée Starå

Hi,

Try something like this.

=INDEX([Minutes Credit/Debit]:[Minutes Credit/Debit]; COUNT([Minutes Credit/Debit]:[Minutes Credit/Debit]))

The same version but with the below changes for your and others convenience.

=INDEX([Minutes Credit/Debit]:[Minutes Credit/Debit], COUNT([Minutes Credit/Debit]:[Minutes Credit/Debit]))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

handmadetsunami

Hi Andrée,

Thanks

It doesn't seem to work, gives me a value of 50, not 60 as expected (see screenshot). 

handmadetsunami

Correction, it does work if I put a 0 in row 1. Why would that be?

Andrée Starå

Happy to help!

It's not working because the first row is empty. You must add a +1.

=INDEX([Minutes Credit/Debit]:[Minutes Credit/Debit]; COUNT([Minutes Credit/Debit]:[Minutes Credit/Debit])+1)

=INDEX([Minutes Credit/Debit]:[Minutes Credit/Debit], COUNT([Minutes Credit/Debit]:[Minutes Credit/Debit])+1)

Did it work?

 



Andrée Starå

It's because of the COUNT part of the formula, see my other answer.

handmadetsunami

Yes thanks for your help

Andrée Starå

Excellent!

I'm always happy to help!