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?
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Brilliant. That has fixed the problem. Much appreciated.
-
Great!
Happy to help!
Have a fantastic weekend!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 501 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 79 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives