Skip to main content
Topics#Data ManagementLindsey Mazzola's Question
Lindsey Mazzola (Lindsey Killmeyer) asked in #Data Management
Mar 4, 2016, 10:31 PM

Help with Formula Field to Set Case Support Level

I am trying to create a formula that will display the Support Level of the Account based on Picklist and Boolean fields. I am getting an error, does anyone have a suggestion on how best to work this out? 

 

IF(AND(TEXT(Account.Support_Level__c) = "Premium 24x7"), 'Premium 24x7', 

 

IF(AND(TEXT(Account.Support_Level__c) = "Treat as Premium"),'Premium 24x7', 

 

IF(AND(TEXT(Account.Support_Level__c) = "Basic 24x7"),'Basic 24x7', 

 

IF(AND(TEXT(Account.Support_Level__c) = "Basic 12x5"),'Basic 12x5',

 

IF(AND(TEXT(Account.Support_Level__c) = "None"), 'None', 

 

IF(AND(Account.Lighthouse_Account__c )  =  TRUE),'Premium 24x7',

 

IF(AND(Account.Critical__c)  =  TRUE),'Premium 24x7',

 

IF(AND(Strategic_Account__c)  =  TRUE),'Premium 24x7','None')))))))

 

Thanks.
8 answers
  1. Sunil Sarilla (M&G Investments)
    Mar 5, 2016, 12:25 AM
    Hi Lindsey,

     

    Please try the below

    IF(
    OR(
    Account.Lighthouse_Account__c,
    Account.Critical__c,
    Account.Strategic_Account__c,
    TEXT(Account.Support_Level__c) = "Treat as Premium"
    ), 
    "Premium 24x7",
    TEXT(Account.Support_Level__c)
    )

     

     
Write an answer...
0/9000