Formula to reverse order of column

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

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!