Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Sep 09, 2022 11:53 AM
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!
Sep 09, 2022 01:23 PM
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}
)