[SalesForce] Need help IF ISPICKVAL Formula field

I have a checkbox and picklist field.I want to have a formula field which evaluates that the checkbox is checked and will assign different values based on user selected picklist field value.

Here is my formula:

(IF(Cognos_BI_Access_Required__c,
    IF(
        OR(
            ISPICKVAL(Project__c, "ITS"),
            ISPICKVAL(Project__c, "Tax Dashboard"),
            ISPICKVAL(Project__c, "VEASI")
        ),
        "ITS Developers/ITS report testers",
        "Corporate Tax",
        "CR_VEASI_USERS"
    ),
    None)
)

But I am getting the below error :

Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 4

Any suggestions?

Best Answer

I believe you're actually looking for CASE, which allows you to map one value to another. Your formula should probably look like this:

IF(Cognos_BI_Access_Required__c,
    CASE(TEXT(Project__c), 
        "ITS", "ITS Developers/ITS report testers",
        "Tax Dashboard", "Corporate Tax",
        "VEASI", "CR_VEASI_USERS",
        NULL),
    NULL
)
Related Topic