Skip to content

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

Does NOT contain formula
I am trying to create a formula that looks at 2 different columns Term Ending Date and Amendment - Ending Date. If column Amendment Date does NOT contain N/A it should return the value in [Amendment -…
Answered ✓
Formulas and Functions
15
Apr 29, 2025
2
Count value in columns
Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up …
Answered ✓
Countif
IF(
Formulas and Functions
21
Apr 28, 2025
1
Formular Workday Count
Hello, I've formula use Workday to count Due date = Start Date @row cell + option days. fx Image below: Start Date is 04/24/25, then added 11 days = Resulted 05/09/25 as Due date. Now, out of curiosit…
Answered ✓
Formulas and Functions
50
Apr 28, 2025
4