https://netsuiteprofessionals.com logo
m

MathewTREW

04/29/2022, 5:21 PM
Is there a formula or function in Saved Searches that will allow for a single criteria line to remove items that contain specific keywords instead of having to create multiple criteria lines to do the same thing? Example: Line 1. Item Name - Does not Contain XXXX Line 2. Item Name - Does not Contain XXXX Formula Thought: Case When {itemname} 'Does Not Contain' XXX OR XXXX, etc
l

Lance Eck

04/29/2022, 8:34 PM
Take a look at this article by Marty Zigman--it's got some good ideas for doing something like this.
👀 1
m

MathewTREW

04/29/2022, 9:02 PM
Thanks! After some trial and error, I learned you can use NOT LIKE to act as the Does Not Contain. You have to use AND instead of OR in the formula to get it to work. Huge time saver.
3 Views