Creating a formula text field that looks at a checkbox field and picklist field

Question

I'm trying to create formula text field that looks at a checkbox field (person of color) and looks at picklist field for gender and then combines values based on what's in those fields. For example if Person of Color checkbox is checked and Gender is Woman then the formula text field would read "Woman of Color".

Here's the formula I have so far but I'm getting an error just not sure where to tweak it

IF(

ISPICKVAL(Gender__c, "man"),

(Person_of_Color__c, true), "Man of Color"),"",

IF(

ISPICKVAL(Gender__c, "Genderqueer, Non-Conforming, or Other"),

(Person_of_Color__c, true),"Person of Color(Other or Unknown)"),"",

IF(

ISPICKVAL(Gender__c, "woman"),

(Person_of_Color__c, false), "Non-POC Woman"),"",

IF(

ISPICKVAL(Gender__c, "man"),

(Person_of_Color__c, false), "Non-POC Man"),"",

IF(

ISPICKVAL(Gender__c, "Genderqueer, Non-Conforming, or Other"),

(Person_of_Color__c, false), "Non-POC(Other or Unknown)"),""

Deepak K Anand · Accepted Answer

Try this =

CASE(
    UPPER(TEXT(Gender__c)) + ":" + IF(Person_of_Color__c, "YES", "NO"),
    "MAN:YES", "Man of Color",
    "MAN:NO", "Non-POC Man",
    "GENDERQUEER, NON-CONFORMING, OR OTHER:YES", "Person of Color(Other or Unknown)",
    "GENDERQUEER, NON-CONFORMING, OR OTHER:NO", "Non-POC(Other or Unknown)",
    "WOMAN:YES", "Woman of Color",
    "WOMAN:NO", "Non-POC Woman",
    NULL
)

Mary Tagler · Answer

IF(  AND(   ISPICKVAL(Gender__c, "Woman"),   Person_of_color = TRUE  ),  "Woman of Color",  (next IF statement) You have some syntax issues. If you want your condition (first prong of the IF statement) to consider tow variables, it should read:

Creating a formula text field that looks at a checkbox field and picklist field

Data Management

Aprendizagem relacionada

Mais ajuda