Skip to main content Tableau Conference is happening now. Tune in to activate your data superpowers with Tableau and Agentforce. Watch live on SF+ for exclusive digital content, new product demos, and key insights for data and analytics lovers.
Topics#FormulasJonathan Sholes's Question
Jonathan Sholes asked in #Formulas
Mar 28, 2023, 8:07 PM

Keeping blank field from checking the checkbox

I am using this formula with return type checkbox, problem is if the field is blank it returns true to the checkbox. Not sure how to keep the box from being checked if it is blank.

 

CONTAINS("KY:MD:MI:MN:MS:MT:NY:OK",Account.BillingState)

6 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Mar 28, 2023, 8:48 PM

    Try adding a NOT ISBLANK 

    AND( 
    NOT(ISBLANK(Account.BillingState)),
    CONTAINS('KY:MD:MI:MN:MS:MT:NY:OK',Account.BillingState)
    )

    or 

     

    AND( 
    LEN(Account.BillingState) = 2,
    CONTAINS('KY:MD:MI:MN:MS:MT:NY:OK',Account.BillingState)
    )
Loading
Write an answer...
0/9000