Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How to write this IF statement so that it "contains" the Text instead of "=" the Text

Topic Labels: Formulas
1160 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Lisa_H
6 - Interface Innovator
6 - Interface Innovator

I have a multi select menu for each job, and so each job may or may contain the GH option, by itself, or with other options.

I am trying to calculate Commission on jobs that CONTAIN GH.
The way I have it now, it only returns commission based on jobs that are ONLY GH.

Any help would be appreciated. Thank you!

IF(Type = “GH”, SUM({Paid (Sold)}*.1))

2 Replies 2

IF(FIND('GH', {Type}),SUM({Paid (Sold)})*.1)

Thank you!!!
Lol man I feel stupid now… IDK why I didn’t think about that.