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 Community Champion

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

My formula is not working, for one specific line in my task sheet. why does it not work
This is the formula, I receive Invalid in the cell =IF(AND(MONTH([Start Date]@row) <= 1, MONTH([End Date]@row) >= 1, YEAR([Start Date]@row) <= 2025, YEAR([End Date]@row) >= 2025), 1, 0)
Count or Sum formula
I want to sum the columns that contain 1 and have tried a SUMIF and COUNTIF Formula, as well as using the AI formula generator within the sheet - nothing is working. As you will see from the screen shot below I would be expecting this column to return a value of 7 but, it just returns 0. I know it's going to be something…
How to flag duplicate dates within a range
Hi everyone, I'm attempting to build an annual leave tracker for my team. The current build is the employee completes a form with Start and End dates > this updates on a Request Log for managers to Approve / Decline > once Approved, copied to a master log and a separate Tracker sheet keeps a list of all employees, their…