Forum Discussion

BaltaD's avatar
BaltaD
Tin Contributor
Aug 29, 2026

Advanced Filter

Hello.

I created a filter that has 2 conditions.  1.  If the Ref Cert or the SK Cert is YES, bit should appear.  The problem is that if the columns with Ref Exp or SK Exp is blank, then it gives me a 0 or if it does have a date, then it gives me the number equivalent.  The original table, it does have dates.  I tried to format the columns so it would give me an actual date, but it doesn't work.  It only works for the blank cells.

This is the actual formula.

=FILTER(C3:N500,((H3:H500)="YES")+((J3:J500)="YES"))&IF(ISBLANK(I3),"",I3)

Array is C3 : N500 (This is the table where is information is coming from)

Ref Cert is H3 : H500

SK Cert is J3 : J500

This is what the finish product looks like.

 

Formulas and Functions

1 Reply

  • m_tarler's avatar
    m_tarler
    Silver Contributor
    Aug 29, 2026

    the result of your IF statement is acting on only I3 and concatenated (&) to the output forcing all the output to be text..  maybe try this:

    =LET(out, FILTER(C3:N500,((H3:H500)="YES")+((J3:J500)="YES")), IF(out=0,"",out))