Formula to reverse order of column

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!