sorting date by Date column not working properly

The parent rows will be sorted first. Then the Child rows will be sorted under the parent rows and will stay under the each of the parent rows.

Think of it as sections.

The 1's will be sorted together underneath of the 1 parent row and same for the 2's. Then 1 and 2 will sort between each other but 1's child rows will stay under the 1 parent row and 2's child rows will stay under the 2 parent row.

Hi @dandoghi

Another option could be to create a report instead.

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) 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!

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

@dandoghi

Happy to help!

More info about reports.

All comments

Do you have any hierarchy in the sheet?

Hi Paul, thanks for checking on this.

Yes, I do, plenty of hierarchies, as the DB is structured in the primary column by Countries, under which the entries are inserted. Is this why the sorting is not working?

Those Country rows are empty on all other columns, except the primary one, which I guess should (not having data in the Date column) should be counted for blank and not considered in the sorting?

Best,

Dan

The parent rows will be sorted first. Then the Child rows will be sorted under the parent rows and will stay under the each of the parent rows.

Think of it as sections.

Thanks a lot Paul! Much appreciated.

I understand now, though there should be some more straightforward and simple way of sorting data data happens to be indented; at least some more options; I hope Smartsheet will develop such.

Meanwhile, I saved the smartsheet as new, added a new column date and copied the adjacent original Date one, and created a filter to exclude date outside 1 Jan to 31 Dec 2019 range --> deleted that and all left was my 2019 data, which then I could expert to excel and have ca 40 entries, from hundreds...

Too much improvisation :)

You should be able to filter and then export only the visible rows which would negate the need to create a separate sheet.

Hi @dandoghi

Another option could be to create a report instead.

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Tried that, as first thing, but it does not work. It copied everything, then it shows then filtered in excel, but it comes with all hidden data together, and thus this improvising; I guess there might be some simpler ways to learn than mine (which for now it helped me). I saw this exporting flaw reported similarly on the net my by many other users...

Thanks

https://community.smartsheet.com/discussion/comment/257790#Comment_257790

Thanks, Andree!

I'll try that, but first I'll need to learn a bit on creating a report...

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

@dandoghi

Happy to help!

More info about reports.

Doug Mounce

Does this mean that the sort is not on a whole number but on the appearance of the number in a date format? Like this?

1/1/21

2/1/21

12/1/21

3/1/21