Help with IF / CONTAINS Function



I am trying to write a formula that will look at a description column, see if it contains a specific string of text, then return a list of adjacent cells where the formula is true.

Said another way, I want to type a string into a cell (A1), look at the description column on another sheet, then return a list in column B of reference numbers that are adjacent to the cells that contain the string from A1.

Any help would be greatly appreciated!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!