How to return a value formula

Hello @biaviera 

Check this base and copy it into your airtable. 
https://airtable.com/appNAsGPvQ93cg8jE/shrszcXrlcLoveA49/tbl4pL39KSJ5CIwpL

Image is attached just for reference.

Formula: 

Your formula is comparing the long text field {inventory tags} with the specific text string "qc". Because you are using the = operator, the formula is checking if the entire value of the {inventory tags} field matches the text string "qc", which it does not because there are other letters in the {inventory tags} field.

Instead, you probably want to check if the {inventory tags} contains the word "qc". There are multiple ways of doing this. One way is to use REGEX_MATCH as dilipborad suggested. You could also use the FIND() or SEARCH() functions. (Some users think FIND() and SEARCH() are easier to understand than the REGEX functions.) They are documented in the Formula Field Reference.

For example

@kuovonne You're right. 👍

Use of FIND() and SEARCH() is more easier as compare to REGEX.