Show if with many categories

[Mas_Andri]

I have a payment list, example Cash,Transfer Bank A, Transfer Bank B, Transfer Bank C and i have a pay proof column. I want when choose Bank Transfer only a payment proof column arrives. How does it how to?

[JuneCorpuz]

Put this in your Show If Formula in your Payment Proof column

AND(
    ISNOTBLANK([Payment List]),
    [Payment List]=“Bank Transfer”
)

[Mas_Andri]

Thanks for the help, but after I tried, the formula didn’t work, the trasfer proof pool didn’t show up, here’s my formula

AND(
ISNOTBLANK([Cara Bayar]),
[Cara Bayar]=“TRF BCA”
[Cara Bayar]=“TRF MANDIRI”
[Cara Bayar]=“TRF BNI”
)

[JuneCorpuz · Accepted solution]

Try this one

AND(
   ISNOTBLANK([Cara Bayar]),
   OR(
      [Cara Bayar]=“TRF BCA”,
      [Cara Bayar]=“TRF MANDIRI”,
      [Cara Bayar]=“TRF BNI”
   )
)

[Mas_Andri]

THANK YOU SO MUCH FOR YOUR HELP