How to make rows sort automatically even when a new row is added.

Alicia D

Is there a way to have the rows that are added with a more recent date to sort to the top of the child rows automatically? I found a way to sort to make this happen. But it does not do it when new rows are added. I always have to re-sort when rows are added. Is there a way to make this happen automatically?

And with that, is there a way to highlight the rows that were added within the last week to a different color just for that week so that there is a clear identifier that they are new rows?

Paul Newcome

The sorting would need to be done through the API or the premium add-on Bridge. Only reports are able to "auto-sort".

Highlighting would be done with the use of a helper [Created (Date)] type system generated column and conditional formatting set to highlight the row when the Created column is within the past 7 days.

Paul Newcome

The sorting would need to be done through the API or the premium add-on Bridge. Only reports are able to "auto-sort".

Highlighting would be done with the use of a helper [Created (Date)] type system generated column and conditional formatting set to highlight the row when the Created column is within the past 7 days.

Alicia D

@Paul Newcome , thank you for the information. The conditional formatting worked!

Paul Newcome

Happy to help. 👍️