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})
))
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.