Formula to reverse order of column

junn

Hi,

Is there a formula in smartsheet to reverse/flip the order of a column from

A

B

C

to

C

B

A

This can be done in excel using an INDEX and ROWS function:

=INDEX($A$2:$A$80,ROWS(A2:$A$80))

however it doesn't seem that SmartSheet has a ROWS function.

Thanks!

-Junn

Paul Newcome

My suggestion would be to insert an auto-number column (called "Auto") as well as a text/number column (called "Row") with this column formula:

=MATCH(Auto@row, Auto:Auto, 0)

Then in the column where you want to order reversed you would use something along the lines of...

=INDEX([Col A]:[Col A], LARGE(Row:Row, Row@row))