Help

How to return a value formula

Topic Labels: Formulas
570 3
cancel
Showing results for 
Search instead for 
Did you mean: 
biaviera
4 - Data Explorer
4 - Data Explorer

Hi can you please help me return the value "qc" from this "inventory tags column"

this formula doesn't seem to work. Thank you!

3 Replies 3
dilipborad
9 - Sun
9 - Sun

Hello @biaviera 

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

dilipborad_0-1702876644168.png

Image is attached just for reference.

Formula: 

 

IF(REGEX_MATCH({inventory tags}, "qc"), REGEX_EXTRACT({inventory tags}, "qc"), BLANK())

 

 

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

 

IF(
  FIND("qc", {Inventory Tags}),
  "pending for qc"
)

 

 

 

@kuovonne You're right. 👍

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