"contains" logic in report builder returns rows that don't include the specific text
I'm building a report where I would like the report to include rows whose primary column includes the text "ORR". The report includes rows that I want, but also includes rows that include the word "correction" because that word includes the same string of characters. Is there a way to limit it so that rows with only that specific text are included?
Best Answer
-
Are any of your valid ORR tasks labeled with anything greater than "ORR"? Like "ORR", "ORR-Review Required" , and "ORR-Final Approval" or is it just "ORR"?
If just "ORR", then change the contains for that part of your and to be "Is Equal To". If there are more like the shot in the dark examples I gave, then I don't believe there is anything further outside of creating a helper column.
Answers
-
Are any of your valid ORR tasks labeled with anything greater than "ORR"? Like "ORR", "ORR-Review Required" , and "ORR-Final Approval" or is it just "ORR"?
If just "ORR", then change the contains for that part of your and to be "Is Equal To". If there are more like the shot in the dark examples I gave, then I don't believe there is anything further outside of creating a helper column.
-
This answers my question but doesn't help me since it requires a helper column as some of the tasks may be labeled with values greater than simply "ORR".
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives