Help

Re: Formula question - if statement and concatenate

619 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Gardner1
7 - App Architect
7 - App Architect

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!

1 Reply 1

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