Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Filter does not recognize "Date is blank"

Anne Abrams
edited 12/09/19 in Archived 2016 Posts

I have created a whole bunch of saved filters that work like a charm.

I need one more, super easy, but can't get it right.

First colum is "Lot #" and the criteria is "contains Spec" - checked.

Second criteria on colum "Date Closed" "Is blank". Simple, isn't it?

Well, when I apply the filter - all the rows where there is a date in the "Date Closed" column are displayed.

If I do the reverse: Date is not blank, then it works perfectly.

What am I doing wrong? (I verified that the "Date Closed" column is formated for dates).

Thank you in advance for your help.


  • ricki
    ricki ✭✭✭✭✭✭

    Thats so weird. I set up a similar filter on a date field that i have and is blank returned all blanks and is not blank returned all not blanks


    Could you possibly have two Date Closed fields in your sheet?

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Have you set the filter to 


    Show rows that match at least one condition


    Show rows that match all


    When there are dates shown, what is the Lot # field?



This discussion has been closed.