Help

Formula question IF statement removing characters

Topic Labels: Formulas
628 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Gardner1
7 - App Architect
7 - App Architect

Hello-

Does anyone know how to remove the : in front of asset type when the Item Descr and the Multi game is blank? I keep getting this

: EMAIL - ANNOUNCEMENT: COMICS PRO - FEB: 2023

Email is the Asset Type

IF(
{ASSET TYPE},
CONCATENATE({ITEM DESCRIPTION LOOK UP},
IF( {MULTI-GAME TASK TYPE}, “” & {MULTI-GAME TASK TYPE}),
IF( {ASSET TYPE}, ": " & {ASSET TYPE}),
IF( {ASSET TASK}, " - " & {ASSET TASK}),
IF({ADDITIONAL ASSET DESCRIPTION}, ": " & {ADDITIONAL ASSET DESCRIPTION})

))
1 Reply 1
autumn
6 - Interface Innovator
6 - Interface Innovator

You might want to consider including separators (":", "-", etc) at the end of the previous item instead of at the beginning of the next item.

Something like this instead:

IF( {MULTI-GAME TASK TYPE}, “” & {MULTI-GAME TASK TYPE}) & ": ",
IF( {ASSET TYPE}, {ASSET TYPE}) & " - ",

If that isn't exactly what you're looking for, I'm happy to try and help more if you share the output you're expecting and what the different values are right now.