Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

CHALLENGE: If Statement based on Category Results

Topic Labels: Formulas
325 2
cancel
Showing results for 
Search instead for 
Did you mean: 

A base used to inventory products.

Current relevant columns are:

  • Product Category (single select with option of Painting, Banner,
  • Description (Formula)
  • Product Name (text)
  • Substrate (single select)
  • Size

These products are categorized

Categories in this Column include:

  • Banners
  • Frames

The Description Column is a formula that creates a meaning full sentenced based product description on the columns. So currently I have:

{Product Category} & " " &
“of” & " " &
{Product Name}
& " " &
“printed on a”
& " " &
{Size}
& " " &
{Substrate}

In this example it will output:
Picture of Glacier printed on a 16 x 20 hardboard gatorfoam

What I need is an IF statement in which if the product category is “Painting” the output will have the words “Printed On” as shown above otherwise this word is not shown

ALSO if Product Category is “Painting” then the output will have the words “of” as shown above… otherwise this word is not shown.

2 Replies 2
{Product Category} & " " & 
IF(
   {Product Category} = "Painting", 
   "of " & {Product Name} & " printed on",
   {Product Name}
) & " a " & {Size} & " " & {Substrate}

THANK YOU SO MUCH, this works perfect.