Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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!
=Index(NPS:NPS;count(NPS:NPS)+2)
The +2 is the empty cells at the top.
Worked!Thanks Luke!
Does anyone know how to revert a sheet to a prior version after a column formula resulted in replacing all of the values with #circular reference? Would all entries have to be manually re-entered?
I know you can use a formula like this: =[Projected Payment Milestones (+)]@row to copy the "value" from one cell to another (because that cell is a formula); however, I need just the "value" formatted as a number ($) to be copied; because in my REPORT I am not able to edit the data as it is recognized as a FORMULA (fx) Is…
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much
