Saved Search filtering using formula (text)
Hi all,
When using a specific text field in netsuite and displaying it as a result, the filter option of this field expects the exact match. For example the result is 135780, it will only bring back the result if the filter is applied as 135780. Is there a way to use perhaps a formula as a filter to accept 5780 and still bring back the result? I can in the results use a text formula to remove all the first two digits from a field value for example, but I'm not sure how to make the filter option accept that or make the connection.