Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Nov 03, 2022 11:21 PM
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})
))
Dec 05, 2022 03:32 PM
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.