Contains

Kelly R.

Hello,

I have a vault number (EX: PB01ALL-PRS-0035-Complete) that contains the word Complete or In process and I would like my formula to return only those vault numbers with the word 'In Process' but for some reason my formula is seeing all the vault numbers and NOT just the ones that contain the word 'In process'.

Any suggestions for my formula - =IF(CONTAINS("Inprocess", [InfoCard Vault]:[InfoCard Vault]), "In Process", "")

For reference my Vault Number Column is text and the column the formula will pull the result in is a dropdown.

Thanks,

Kelly

Kelly R.

Hi Eric,

I ended up figuring it out. I needed the formula to look @row vs the entire column. Appreciate your willingness to help.

Kelly

Eric Law

@Kelly R. Can you provide a screenshot?

Kelly R.

Hi Eric,

I ended up figuring it out. I needed the formula to look @row vs the entire column. Appreciate your willingness to help.

Kelly