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.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!