Welcome!

Report not filtering correctly

I have two named items in a column that I need to have on separate reports:

1) Machining

2) Machining (CNC)

When I put contains 'Machining' under the 'What' part of the report, it pulls in 'Machining CNC'.. It is not allowing me to have on separate reports. Can anyone assist?

Find more posts tagged with

Comments

Andrée Starå

Hi,

It's because contains looks for the word Machining in the whole column name. You have to change it to is equal to" Machining and that will only return the column Machining and not the Machining (CNC).

Would that work?

I hope this helps you!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

TeeM

Brilliant. That has fixed the problem. Much appreciated.

Andrée Starå

Great!

Happy to help!

Have a fantastic weekend!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Slow loading
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
Report that includes multiple sheets
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
Revise Filter in Dashboard
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?