isblank

Hi

how to apply ISBLANK in Boolean format for multiple columns.

I am not getting error if it is one column but if it is for multiple columns Im getting error

IF ISBLANK(Market) THEN TRUE ELSE FALSE

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In

Best Answer

  • Hello @SwapnaB,

    What do you mean multiple columns, multiple Line items? If so, you dont need the entire statement.

    1. If you want it to be TRUE when all of them are blank: ISBLANK(A) AND ISBLANK(B) AND ISBLANK(C )
    2. Id you want it to be TRUE when one of them is blank: ISBLANK(A) OR ISBLANK(B) OR ISBLANK(C )

    where A, B, and C are the line item names.

    Hope that makes sense!

    Kind regards,

    Bruno Rodriguez

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In