Filter suddenly not working

Mark Welch
Mark Welch ✭✭
edited 12/09/19 in Formulas and Functions

Hi All,

 

I have an issue of a filter not working that previously worked fine.

The filter looks for cells in a column formatted for text/numbers.

Here's an example of the data in the column:

NLOND_3104-1

NLOND_3709-2

-2

-1

-2

NLOND_5612-1

 

The filter looks for data that contain -1 and another filter looks for data that contains -2.

However it now only reports data with the text in front of it. The -1 and -2's on their own cannot be found. Only the NLOND##### is reported.

 

Has anyone got any ideas?

 

Thanks,

Mark

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!