Formula question - if statement and concatenate

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.