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"

Options
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.

Comments

  • ricki
    ricki ✭✭✭✭✭✭
    Options

    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 ✭✭✭✭✭✭
    Options

    Have you set the filter to 

     

    Show rows that match at least one condition

    or

    Show rows that match all

     

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

     

    Craig

This discussion has been closed.