I am trying to create an nested IF AND conditional statement to look at case severity and time (hrs) it took to reach a certain case status. I have tried the below but keep getting the error
"Warning Error when encoding row-level formula: Field Case.b1_case_severity__c is a picklist field. Picklist fields are only supported in certain functions."
From what I have searched I may need to use
CONTAINS(TEXT( but don't know where I would apply it in the formula.
IF( AND(Case.b1_case_severity__c, "1 - Critical", Case.Flexible_SLA_Time__c > 9.5),1, IF( AND(b1_case_severity__c, "2 - High", Case.Flexible_SLA_Time__c > 9.5),1, IF( AND(b1_case_severity__c, "3 - Medium", Case.Flexible_SLA_Time__c > 19),1, IF( AND(b1_case_severity__c, "4 - Low", Case.Flexible_SLA_Time__c > 28.5),1,0))))