HELP IF FUNCTION
Hello,
I need build a formula from the options to Create Custom Field in Cases.
I have a field called Type, which has these values:
Presales: Simple Query
Presales: Sizing
Presales: Validation of Technical Specifications
Presales: Response Technical Specifications
Presales: Technical Specifications Design
Presales: Opportunity Detection
Presales: Virtual Demo
Presales: Pilot (POC)
Presales: Demand Generation (Final)
Presales: Demand Generation (Partners)
Each of these values, show a kind of task, which has a "value" or "unit" administrative measure used to count them and then bill the service. The values for each unit, as the case would be:
Presales: Simple Query = 1
Presales: Sizing = 3
Presales: Validation of Technical Specifications = 12
Presales: Response = 32 Technical Specifications
Presales: Technical Specifications Design = 150
Presales: Opportunity Detection = "Need Quote"
Presales: Demo Virtual = "Need Quote"
Presales: Pilot (POC) = "Needs Summary"
Presales: Demand Generation (Final) = "Needs Summary"
Presales: Demand Generation (Partners) = "Needs Summary"
It should build an IF function but is showing me Error.Missing Quotes.
I need build a formula from the options to Create Custom Field in Cases.
I have a field called Type, which has these values:
Presales: Simple Query
Presales: Sizing
Presales: Validation of Technical Specifications
Presales: Response Technical Specifications
Presales: Technical Specifications Design
Presales: Opportunity Detection
Presales: Virtual Demo
Presales: Pilot (POC)
Presales: Demand Generation (Final)
Presales: Demand Generation (Partners)
Each of these values, show a kind of task, which has a "value" or "unit" administrative measure used to count them and then bill the service. The values for each unit, as the case would be:
Presales: Simple Query = 1
Presales: Sizing = 3
Presales: Validation of Technical Specifications = 12
Presales: Response = 32 Technical Specifications
Presales: Technical Specifications Design = 150
Presales: Opportunity Detection = "Need Quote"
Presales: Demo Virtual = "Need Quote"
Presales: Pilot (POC) = "Needs Summary"
Presales: Demand Generation (Final) = "Needs Summary"
Presales: Demand Generation (Partners) = "Needs Summary"
It should build an IF function but is showing me Error.Missing Quotes.
If(Contains${Cases.Type=='Preventa: Piloto (POC)'},'Necesita Cotizacion',0)
Please, if you think I'm wrong function, please send me an example?
I attached a screenshot of the setup screen for more info.
Someone could help me?
From already thank you very much!