Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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.
Have you tried switching the sort order from descending to ascending?
The blank %complete still show at the bottom.
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
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.
Posted more explanation. Thank you for looking at the issue.
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)
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.
I created some dummy sheets and report and shared.
Thanks!
I'll take a look and get back to you!
I saw that Paul answered already!
Let me know if I can help with anything else!
Andrée
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.
I'm always happy to help!
Glad you got it working!
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
When i try to send or print the timeline view instead of showing the progression bars like they do on the screen it only send the data entered and not a graph type view to print. Is there a way to do this. I am using a mac platform if that helps.
