Hi community,
I need your help.
There is something i don’t understand with the formula bellow :
IF(
SEARCH("Jungle", {Order Line Items}),
"Jungle",
IF(
SEARCH("Baby Plantes", {Order Line Items}),
"Baby plante",
IF(
SEARCH("Pets Friendly", {Order Line Items}),
"Pet's Friendly"
)
)
)
I want to write a 4th condition but it never work.
What is the importance of the space between the condition and the “)” ? How can i built easly this type of formula ?
Thank’s a lot,
Matthieu
