+ Start a Discussion
Vickie SmithVickie Smith 

Trying to make a new custom Field with a IF formula

I'm trying to make a field that will update in a conga templete

CASE(TEXT(Intl_Dom__c),
'I','Round trip shared transfers are included between the airport and resort for all international destinations',
'D','For Las Vegas, round trip shared transfers are available for an additional $19.00 per person going downtown or $14.00 per person to the strip')

I've also tried -

CASE(TEXT(Intl_Dom__c),
'I','Round trip shared transfers are included between the airport and resort for all international destinations',
'D','For Las Vegas, round trip shared transfers are available for an additional $19.00 per person going downtown or $14.00 per person to the strip')

but will get an error message

Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 4

Can someone help me out with this please?
Best Answer chosen by Vickie Smith
Maharajan CMaharajan C
Hi Vickie Smith,

You need to give the Else Result value also in the CASE Formula.

General Syntax : CASE(expression,​value1, result1, value2,​ result2,...,​ else_result)

Just i updated the Small thing in your Formula :

CASE(TEXT(Intl_Dom__c),
'I','Round trip shared transfers are included between the airport and resort for all international destinations',
'D','For Las Vegas, round trip shared transfers are available for an additional $19.00 per person going downtown or $14.00 per person to the strip','There is a No Trip') .

Can you please test it now and let me know.

Let me know if you want any further help.

If those points are help means mark these as a best answer.

Thanks,
Raj
(Sweet Potato Tec)

All Answers

Maharajan CMaharajan C
Hi Vickie Smith,

You need to give the Else Result value also in the CASE Formula.

General Syntax : CASE(expression,​value1, result1, value2,​ result2,...,​ else_result)

Just i updated the Small thing in your Formula :

CASE(TEXT(Intl_Dom__c),
'I','Round trip shared transfers are included between the airport and resort for all international destinations',
'D','For Las Vegas, round trip shared transfers are available for an additional $19.00 per person going downtown or $14.00 per person to the strip','There is a No Trip') .

Can you please test it now and let me know.

Let me know if you want any further help.

If those points are help means mark these as a best answer.

Thanks,
Raj
(Sweet Potato Tec)
This was selected as the best answer
Vickie SmithVickie Smith
Thank you! That worked great!