Question:
I need the ability to have an open text field show up called Text in my field IF the Item Description is Blank. So it would look like, CORPORATE REQUEST: ‘TEXT’.
IF(
{ITEM DESCRIPTION}=BLANK(),‘CORPORATE REQUEST’,
CONCATENATE(
{ITEM DESCRIPTION},
IF( {ASSET TYPE}, " - " & {ASSET TYPE}),
IF( {COPY TYPE}, ": " & {COPY TYPE}),
IF( {MEDIA TYPE}, ": " & {MEDIA TYPE})
)
)
Thanks!
Hey @Scott_Gardner1!
Similar to this?
IF(
{ITEM DESCRIPTION},
CONCATENATE(
{ITEM DESCRIPTION},
IF(
{ASSET TYPE},
" - " & {ASSET TYPE}
),
IF(
{COPY TYPE},
": " & {COPY TYPE}
),
IF(
{MEDIA TYPE},
": " & {MEDIA TYPE}
)
),
"CORPORATE REQUEST: " & {TEXT}
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.