Anas Jakwani
10/03/2025, 9:25 AMCeligo AI
10/03/2025, 9:26 AMAI generated answer (using internal Slack threads):To add the result of a formula text from a saved search in the available filters, you need to set up the
Formula (Text) field as a criteria. However, only the first formula of each type (text, currency, date, etc.) in your results set can be used as an available filter.
Here are the steps to do this:
1. Add your formula field in the criteria of the saved search.
2. Make sure that the formula field is the first field under the Results and Available Filters subtabs.
3. Select "Formula(Text)" as a filter. The first formula text in your results will be available.
Please note that this might not work perfectly and you might not get search results when filtering an obvious result. This is a known limitation in NetSuite.
As a workaround, you can use a nominal amount for the default search, for example, 100. Then add Formula (Text) as an Available filter. Another solution might be to use a Dashboard 'Search Form' which works from the criteria from the Results columns instead of in Criteria.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
10/03/2025, 9:26 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.883850157
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.858886778
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.858154356
Celigo AI
10/03/2025, 9:26 AM