Index Collect Formula with Specific Text


We have one sheet with all of our projects in a column with various other columns of data associated. I am hoping to determine the best formula to look at all project names on this sheet and return them all to a column on new sheet if they have "Cliff" in the project name.

I have tried a few different ways and none seem to work. Below are the variables.

{PEC Blueprint Summary Sheet - DO NOT EDIT Range 1} = Name of the column on alternate sheet that has all project names listed.

[Column2]1 Column on new sheet to return Project Name

I believe that Index Collect may be the best formula, but are two different columns needed to return if value is found and then to copy?

Any help is greatly appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!