Sorting by percent complete

Tom Parham

I originally created a report that showed all the sheets I was assigned to a specific task ans sorted by percent complete and then by sheet name. The sheets that had nothing in the percent complete used to appear at the top now they appear at the bottom. Without having to enter a 0 in every sheet that has not started the task what option would I have to get the blank sheets back to the top.

Paul Newcome

Have you tried switching the sort order from descending to ascending?

Tom Parham

The blank %complete still show at the bottom.

Andrée Starå

Hi Tom,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Tom Parham

Sorting the report with %complete ascending the sheets sort lowest to highest then put any sheets with no value in the %complete at the bottom. Sort descending sorts them descending and the sheets with no value show at the bottom as well. This is not how it used to work. Sheets with no value (tasks I have not started yet) used to show at the top so I can see what installs are coming up at the top.

Tom Parham

Posted more explanation. Thank you for looking at the issue.

Andrée Starå

Happy to help!

Can you maybe share the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Paul Newcome

What about an additional column where you would enter something along the lines of...

 

=IF(ISBLANK([% Complete]@row), 0, [% Complete]@row)

 

Granted this is basically placing a 0 in each of the empty rows, but it is automating it so you can dragfill the formula instead of having to look row by row.

 

You can then include this new column on your report, hide it, and sort by it instead.

 

If you wanted it sorted in descending order with blanks on top, you would replace the 0 with any number higher than 1.

 

The actual % Complete column would be displayed on your report, but the hidden column would be determining the sort order. 

 

Note: When I have done this in the past I typically name this additional column "Sort" or "Sort By" or something to that affect so that I can easily find it in my list and know exactly which one I want to sort by.

Tom Parham

I created some dummy sheets and report and shared.

Andrée Starå

Thanks!

I'll take a look and get back to you!

Andrée Starå

I saw that Paul answered already!

Let me know if I can help with anything else!

Best,

Andrée

Tom Parham

I have just been scrolling to the bottom and adding a 0 to any new sheets. I might automate it with a formula but new sheets come in 2-3 per week so not so bad. It's just odd it changed the sort order after I created the report.

Thanks for looking at it.

Andrée Starå

I'm always happy to help!

Glad you got it working!