Help

Formula question IF statement removing characters

Topic Labels: Formulas
56 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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})

))
0 Replies 0
Labels