Getting Value of Last Row

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

Find more posts tagged with

Sheets

Formulas

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…