Using IF and Concat Calculation together

[Martin Furse]

Hi I am wondering if anyone can see what I am doing wrong with the following calculation:

IF(Party Status)
=”Party1″;CONCAT(LEFT(
, 3), RIGHT(
, 3));”Nothing”)

Party Status is the Field Name and Party 1 forms part of a “Single Value Popover” Picklist.

The result I am after is to return the CONCAT providing the Party Status equals “Party One”
What seems to be happening is the If calculation is not being triggered and regardless of what Single Value picklist I use, it will still return the CONCAT.

Thank you in advance

Trusty

[Martin Furse]

Apologies – The calculation didn’t all copy across but in the CONCAT I have First Name and Last Name, so:
IF(Party Status)
=”Party1″;CONCAT(LEFT(First Name
, 3), RIGHT(Last Name
, 3));”Nothing”)

Cheers
Martin

[Brendan]

Hi Martin,

For the IF() function, you should use IFEQUAL() instead when comparing text values. The IF() function is for doing numeric comparisons.

So it would be:

IFEQUAL(Party Status; "Party 1"; LEFT(First Name; 3) + " " + RIGHT(Last Name; 3); "Nothing")

You don’t have to use CONCAT(). You can just use + to concatenate strings together. I put a space in there just for example.

Thanks,

Brendan

[Martin Furse]

Thank you Brenan, It worked a treat!

[Author]

Posts