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

X M

Hi

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?

Thanks

Xav..

Paul Newcome

A filter will not work as it is designed to simply show/hide rows based on specific criteria. You would need to use the sorting feature either in the sheet which would need to be done manually or through a report which would happen automatically.

There is currently no way to have a Copy Row automation add the rows to the top of the sheet.

Andrée Starå

@xav Happy to help!

Paul Newcome

Have you tried looking at the Sort feature? It allows you to specify a column to sort on and then select ascending or descending.

X M

Thanks for your reply Paul.

Yes I did but it defaults to Ascending so I have to manually redo the sorting to see the newest row added to the top of the sheet every time a new row is added which what I want to avoid as it is a waste of my time.

Paul Newcome

What is the reason for the sort? If it is only to view, you can create a report that will simply pull all rows. Sheet sorting is not automatic, but report sorting is.

X M

The reason for the sort is to have the newest rows added at the top of the sheet not at the bottom, which is not current happening in my sheet. To overcome this issue, my tentative solution was to set a filter based on the date of their addition to the sheet.

I would rather build a filter that displays the data the way to need them to be than having to build another report.

Paul Newcome

A filter will not work as it is designed to simply show/hide rows based on specific criteria. You would need to use the sorting feature either in the sheet which would need to be done manually or through a report which would happen automatically.

There is currently no way to have a Copy Row automation add the rows to the top of the sheet.

Andrée Starå

@xav

Hi,

To be able to have the rows added at the top of the sheet would be excellent.

Please submit an Enhancement Request when you have a moment

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

X M

Thanks Paul for your help.

@Andrée, I will submit an enhancement request.

Thanks

Xav..

Andrée Starå

@xav Happy to help!