Filter suddenly not working

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

Find more posts tagged with

Formulas

Hi Mark,

Strange!

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Thanks, ticket entered.

Excellent!

Happy to help!

How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])