Help

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

Formula question IF statement removing characters

Topic Labels: Formulas
253 1
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})

))
1 Reply 1

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.