How to order rows from a Auto Number/System column?

X M ✭✭✭✭
edited 03/30/20 in Formulas and Functions


I have a sheet A (SA) that is populated by copying row from sheet B (SB). When a new row is added to SB, I have a "Created" column set up as Auto Number/System column (System-generated column =Created (Date) ) which allows me to identify when the row has been added.

I want to filter the rows based on the dates they have been added using that Auto Number/System column (the newest at the top of the sheet and oldest at the bottom).

I tried to create a filter but I do not any option that would allow me to display the result I am looking for.

Anybody ran into this issue before and resolved it successfully?



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!