You need to sign in to do that
Don't have an account?
Vickie 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?
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?
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
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)