Build a Report by Filtering Multiple Criteria contained in one Column.

edited 07/03/22 in Formulas and Functions

Hi all. I'm building a report by filtering one column to see if it contains number 1 OR number 2 OR number N. However, the list of numbers that I need to filter is quite long (also the list is in another sheet), therefore is not a good idea to filter this number one by one.

Any ideas?.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!