Skip to main content
Stephen Bailey (Salesforce) 님이 #Data Management에 질문했습니다
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개
  1. 2020년 3월 30일 오후 7: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)