Skip to main content
I currently want this formula field to populate when moquito treaments checkbox is selected. When the checkbox is selected an the corresponding picklist values values to display. If the values are not selected I want this formula field to remain blank. Below is what I have so far.

 

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 respostas
  1. 30 de mar. de 2020, 19:01

    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)