Help Needed with IF and SEARCH Formula in Stackby

Ask the Community Formulas
#1

I’m trying to create a formula that checks for specific keywords within a label and returns a certain value if those keywords are present. Specifically, I want to check if the label contains the word “PAYMENT” or “No PAYMENT” and return “Yes” if either of these conditions is met

#2

To create a formula that checks if a label contains the keywords “PAYMENT” or “No PAYMENT” and returns “Yes” if either condition is met, you can use the following formula:

IF(
  OR(
    SEARCH("PAYMENT", {Label}),
    SEARCH("No PAYMENT", {Label})
  ),
  "Yes", " "
)