Formula - sperate by comma

[Scott_Gardner1]

Hello-

I have this one also:

IF(
{MARKETING CAMPAIGN},
CONCATENATE(
{MARKETING CAMPAIGN},
IF( {ASSET TYPE}, " | " & {ASSET TYPE}),
IF( {ASSET TASK}, " - " & {ASSET TASK}),
IF( {CAMPAIGN TYPE}, ": " & {CAMPAIGN TYPE}),
IF( {CORPORATE TASK DESCRIPTION}, " - " & {CORPORATE TASK DESCRIPTION})

),
‘MARKETNG REQUEST’
& ’ | ’ &{ASSET TYPE}
& ': ’ &{ASSET TASK}
& ': ’ &{Item Description})

Need to have a comma separation when the item description is multiple so it doesn’t look like this:

abcd

Need - a,b,c,d

Thanks!

[WilliamPorter]

If you want something to appear in field Y only when field X is NOT empty, you use a formula element like this:

If(X, «insert your result here»)

It’s not necessary in this case to add a third “then” clause to the IF construction. If the condition isn’t met, nothing happens (and in the example here, Y remains empty).

But I don’t really understand where your smiley face is coming from. You didn’t mention that earlier. If it’s coming from the ‘Marketing Campaign’ field, then that field is NOT blank. A smiley face isn’t much, but it’s not a blank.