Action Trigger: Not Equal to NULL/BLANKS

[kfahri342]

Hi All

I have the following column:

Type A
Dec-17
Jan-18
TBC
Aug-17

As you can see there is a mixture of dates, text and NULL values in this column. I have created a button where I want to TOGGLE SELECT "Type A" to only select Non-Null values.

I have tried the follow: <>"". But this only seems to show me the dates, and does not include the TBC. Is there a formula where I can select any that isn't NULL?

Many Thanks

Kozan

[Anonymous]

How about

=len([Type A])<>0

[kfahri342]

Thanks for the suggestion. But that has no affect

[Anonymous]

Try attached

[kfahri342]

This works perfectly. Cheers Wallo.

For one of my columns I would need it to include all NON-BLANKS except for those marked N/A? Is this do-able? I tried using an AND function but either I am not typing it right or it doesn't work.