Help

Re: CHALLENGE: If Statement based on Category Results

397 1
cancel
Showing results for 
Search instead for 
Did you mean: 
HNC
5 - Automation Enthusiast
5 - Automation Enthusiast

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}
HNC
5 - Automation Enthusiast
5 - Automation Enthusiast

THANK YOU SO MUCH, this works perfect.