Display last value in column

vanzin

vanzin ✭

05/29/18 edited 12/09/19 in Formulas and Functions

Hello Community!

My question is quite simple. (I hope).

How can I display the last value of a column? I tried to use the formula = INDEX, but I could not read the last number automatically.

Thanks!

Tags:

Formulas

0 ·

Comments

L_123 ✭✭✭✭✭✭

05/29/18

=Index(NPS:NPS;count(NPS:NPS)+2)

The +2 is the empty cells at the top.

0 · Share on Facebook Share on Twitter
vanzin ✭

05/29/18

Worked!

Thanks Luke!

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Help with Average Formulas
Hi! I am trying to calculate a 3 months, 6 months and 1 year averages of my team utilization percentage. Each team member is a row and then each month is a column. The utilization percentages are coming from other sheets. Thank you in advance!
Need Help with a Formula
I'm trying to create a formula that says if the date in the "due date" column is between 60 and 90 days from today, mark yellow I've tried a few things but can't figure it out. Can anyone help?
Count the number of times a person's name appears in an "Assigned To" column
I currently use the below formula to count the number of times a name appears in the "Assigned To" column. The issue is that this column can have multiple names in the same cell, so I have to created a separate formula for every possible name combination. Is there a way to have a formula that looks for a name string and…