Skip to main content
Topics#Data ManagementPregunta de Amin Ahcene
Amin Ahcene preguntó en #Data Management
14 jul 2020, 10:17

Checkbox formula

Hello, 

 

I would like to have a chackbox that is  checked if the product name contain "SEARCH RESULT PAGE" and if we are in betwen the service periode.

 

 

 

IF( PricebookEntry.Product2.Name ,CONTAIN ( SEARCH RESULT PAGE )

 

AND( 

 

    ServicePeriodStart__c  <= TODAY(), 

 

    ServicePeriodEnd__c   >= TODAY()

 

)

 

Thanks in advance for the help 
2 respuestas
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    14 jul 2020, 10:19
    Hi Amin,

     

    Your formula should be like so as long as ServicePeriodStart__c and ServicePeriodEnd__c are date fields:

    AND(CONTAINS( PricebookEntry.Product2.Name ,"SEARCH RESULT PAGE" ),
        ServicePeriodStart__c  <= TODAY(), 
        ServicePeriodEnd__c   >= TODAY()
    )

     

     
Escribir una respuesta...
0/9000