Skip to main content

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.

{Product Category} & " " & 

IF(

   {Product Category} = "Painting", 

   "of " & {Product Name} & " printed on",

   {Product Name}

) & " a " & {Size} & " " & {Substrate}


{Product Category} & " " & 

IF(

   {Product Category} = "Painting", 

   "of " & {Product Name} & " printed on",

   {Product Name}

) & " a " & {Size} & " " & {Substrate}

THANK YOU SO MUCH, this works perfect.

Reply


Terms & Conditions