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

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