In the meantime, how do I fix this custom parent industry field I am trying to create. I am trying to source a parent industry when a sub industries appears, and mark it "undefined" when there it is NULL. I keep getting a "need a )" error.
IF
(ISBLANK(Industry),"Undefined",
IF(CONTAINS(
"Aerospace","Aerospace & Defense",
IF(CONTAINS(
"Auto Rental",Industry),"Automotive",
"Undefined")))
7 answers
First you sasss the Awesome SteveMo, then you ask for help....... Hmmmmmm.
I added a few parens in key places:
IF(ISBLANK(TEXT(Industry)),
"Undefined",
IF(CONTAINS(TEXT(Industry),"Aerospace"),"Aerospace & Defense",
IF(CONTAINS(TEXT(Industry),"Auto Rental"),"Automotive", "Undefined")
)
)
