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

Comments

  • Yes Bruno thank you so much

  • Hi Bruno

    I need your help here to get his last active plan as complan in one of the modules'

    Can we please connect