Filter to show blank cells?

Hey! I am looking to filter data to show columns that have empty cells. For example showing all results where 'Planning Condition Status' is blank.

I had a look at doing a Beast mode formula but wasn't sure how to put 'Blank' in the formula? Is there an easier way for me to do this?

Thankyou in advance.

Best Answer

  • GrantSmith
    GrantSmith Indiana 🥷
    Answer ✓

    You can do something like this to handle NULL / empty values:

    CASE WHEN `Planning Condition Status` IS NULL THEN 'Blank' ELSE 'Not Blank' END
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**