CASE( Estimated_Sq_Ft__c ,
"0-2,999", 30,
"3,000-3,999", 30,
"4,000-4,499", 30,
"4,500-4,999", 35,
"5,000-5,499", 35,
5)
Mosquito_Treatments__c = TRUE
답변 11개
Try like this:
IF(Mosquito_Treatments__c = TRUE,
CASE(Estimated_Sq_Ft__c ,
"0-2,999", 30,
"3,000-3,999", 30,
"4,000-4,499", 30,
"4,500-4,999", 35,
"5,000-5,499", 35,
5),
NULL)