Help with IF / CONTAINS Function

Hi!

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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!