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