Type = Discovery Call
Status = Completed
Then the grade will be calculated based on a number field.
I currently have this formula but not sure how to add that Type and Status must equal specific values
IF(Discovery_Call_Score__c <50, "D",
IF(Discovery_Call_Score__c >60 && Discovery_Call_Score__c<49, "C",
IF(Discovery_Call_Score__c >59 && Discovery_Call_Score__c<80, "B",
IF(Discovery_Call_Score__c >79, "A",null))))
답변 29개
Give this a formula try :
IF(
AND(TEXT(Type) = "Discovery Call",TEXT(Status)= "Completed"),
IF(Discovery_Call_Score__c > 79, "A",
IF(Discovery_Call_Score__c > 59 ,"B",
IF(Discovery_Call_Score__c > 49, "C",
"D"))),NULL)
