Any suggestions would be appreciated. Thanks.
If conditions are met then the value in the field should be 1 of the 4 options.
JMP Staff
Early Adopter
Software Admin
Premier
Here is my current formula where I'm getting the error (Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 2)
IF(
AND(
NOT(ISBLANK(ECUSTOMS__RPS_Date__c)),
NOT(
OR(
ECUSTOMS__IM_Status__c = "-",
ECUSTOMS__IM_Status__c = "Cleared",
ECUSTOMS__IM_Status__c = "False Hit",
ECUSTOMS__IM_Status__c = "Actioned",
ECUSTOMS__IM_Status__c = "Escalated",
ECUSTOMS__IM_Status__c = "Closed RPS",
ISBLANK(ECUSTOMS__IM_Status__c)
)
),
SAS_JMP_Employee__c = TRUE
),
"01. JMP Staff",
IF(
FALSE,
"02. Early Adopters",
IF(
AND(
OR(
CONTAINS(ECUSTOMS__RPS_Status__c, "Red"),
CONTAINS(ECUSTOMS__RPS_Status__c, "Yellow")
),
NOT(
OR(
ECUSTOMS__IM_Status__c = "-",
ECUSTOMS__IM_Status__c = "Cleared",
ECUSTOMS__IM_Status__c = "False Hit",
ECUSTOMS__IM_Status__c = "Actioned",
ECUSTOMS__IM_Status__c = "Escalated",
ECUSTOMS__IM_Status__c = "Closed RPS",
ISBLANK(ECUSTOMS__IM_Status__c)
)
),
INCLUDES(External_User_Audience__c, "Software Admin"),
AccountId <> "0015b00002KdPf4AAF"
),
"03. Software Admin",
IF(
AND(
NOT(ISBLANK(ECUSTOMS__RPS_Date__c)),
OR(
ECUSTOMS__RPS_Status__c <> "No Matches",
ECUSTOMS__RPS_RiskCountry_Status__c = "Alert"
),
Sales_Region__c = "Strategic",
Assigned_Authorizations__c > 0,
NOT(
OR(
ECUSTOMS__IM_Status__c = "-",
ECUSTOMS__IM_Status__c = "Cleared",
ECUSTOMS__IM_Status__c = "False Hit",
ECUSTOMS__IM_Status__c = "Actioned",
ECUSTOMS__IM_Status__c = "Escalated",
ECUSTOMS__IM_Status__c = "Closed RPS",
ISBLANK(ECUSTOMS__IM_Status__c)
)
),
OR(
Account.RecordTypeName__c = "Site Account",
Account.RecordTypeName__c = "User Location",
Account.RecordTypeName__c = "Enterprise Account",
Account.RecordTypeName__c = "JMP Subscription",
Account.RecordTypeName__c = "Customer Account",
Account.RecordTypeName__c = "SAS Transitional",
Account.RecordTypeName__c = "Reseller Account",
Account.RecordTypeName__c = "Related Entity",
ISBLANK(Account.RecordTypeName__c)
),
OR(
ISPICKVAL(Account.Account_Status__c, "Pending Approval"),
ISPICKVAL(Account.Account_Status__c, "Descartes Review"),
ISPICKVAL(Account.Account_Status__c, "Export Compliance Review"),
ISPICKVAL(Account.Account_Status__c, "Approved"),
ISPICKVAL(Account.Account_Status__c, "Waiting on Information"),
ISPICKVAL(Account.Account_Status__c, "eCommerce Approved"),
ISPICKVAL(Account.Account_Status__c, "MEQ Approved"),
ISBLANK(TEXT(Account.Account_Status__c))
)
),
"04. Premier"
))))
#Formulas
