Welcome!

Sorting by date (ignoring blanks)

Sorry for the easy question. I've looked around and can't find the answer.

I have a report full of dates, some of the dates are also blank. When I sort the column by ascending date, it starts with all the blanks, then the earliest date to the latest.

when i sort descending, it gives me the latest date first to the earliest, the the blanks.

i'm looking for, earliest date to latest date THEN blanks.

this is in a report, so i can't use a formula.

Find more posts tagged with

Comments

Paul Newcome

You would need to add something to the source sheet that will essentially place the blank dates last. Something like a checkbox column with a basic

=IF(ISBLANK(Date@row), 1)

This will check the box for all rows that have blank dates. Include this column on your report (it can be hidden on both the report and sheet after setting it up), and sort by that first.

Sort by: Helper Column/Descending

Then by: Date Column/Ascending or Descending (whichever you need)

ArthurC

While this solution will work, it's not that practical.

I have a list of people, and a column of dates of when they are scheduled, not everybody is scheduled but i want to know the most recent.

I would then have to have people when they are inputting the dates, to also check off the box for helper.

Paul Newcome

"I would then have to have people when they are inputting the dates, to also check off the box for helper. "

No. The formula provided automatically checks the box if a date is blank, and will remain unchecked if there is a date. The whole reason for the formula in the Helper column is for the automation of the process.

=IF(ISBLANK(Date@row), 1)

Sign in to join the conversation!

Trending discussions

I am getting an error message when attempting to export to excel
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Need Help w/ Report View - Nothing Is Showing
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…