isblank

SwapnaB
SwapnaB
in Academy and learning discussions

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

  • BrunoRodriguez
    BrunoRodriguez
    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

  • SwapnaB
    SwapnaB

    Yes Bruno thank you so much

  • SwapnaB
    SwapnaB

    Hi Bruno

    image.png

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

    Can we please connect

Categories