# I am unable to use the Formula (Text) in the Additional search criteria **URL:** \ **Category:** Integrator.io\ **Tags:** filter, lookup, netsuite\ **Created:** [May 28, 2021, 3:03pm UTC](https://connective.celigo.com/t/i-am-unable-to-use-the-formula-text-in-the-additional-search-criteria/1089 "2021-05-28T15:03:09Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![marcreid](https://avatars.discourse-cdn.com/v4/letter/m/58956e/32.png) [@marcreid](https://connective.celigo.com/u/marcreid)\ **Post date:** [May 28, 2021, 3:03pm UTC](https://connective.celigo.com/t/i-am-unable-to-use-the-formula-text-in-the-additional-search-criteria/1089/1 "2021-05-28T15:03:09Z")
I have to filter some records from the Lookup step save search. To filter out the result I have to use the Formula (Text) field. ![5301043caa20740200000001-4c11f6fae4bd495899890ac87286d970.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/4fdc389ad770d174b8c73ee0e416a93ba4347c2f.png) ---
**Author:** ![katelarson](https://avatars.discourse-cdn.com/v4/letter/k/91b2a8/32.png) [@katelarson](https://connective.celigo.com/u/katelarson)\ **Post date:** [May 28, 2021, 8:07pm UTC](https://connective.celigo.com/t/i-am-unable-to-use-the-formula-text-in-the-additional-search-criteria/1089/2 "2021-05-28T20:07:31Z")
Hi @marcreid, Thank you for letting us know about this issue. We have submitted this request to our engineering team. Kate ---
**Author:** ![marlshanthana](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@marlshanthana](https://connective.celigo.com/u/marlshanthana)\ **Post date:** [June 6, 2021, 8:30pm UTC](https://connective.celigo.com/t/i-am-unable-to-use-the-formula-text-in-the-additional-search-criteria/1089/3 "2021-06-06T20:30:18Z")
Any updates on this..? ---
**Author:** ![katelarson](https://avatars.discourse-cdn.com/v4/letter/k/91b2a8/32.png) [@katelarson](https://connective.celigo.com/u/katelarson)\ **Post date:** [June 7, 2021, 8:36pm UTC](https://connective.celigo.com/t/i-am-unable-to-use-the-formula-text-in-the-additional-search-criteria/1089/4 "2021-06-07T20:36:42Z")
Hi @marlshanthana - I'm checking with the product manager and will provide an update here when I receive information. Thanks! Kate ---
**Author:** ![katelarson](https://avatars.discourse-cdn.com/v4/letter/k/91b2a8/32.png) [@katelarson](https://connective.celigo.com/u/katelarson)\ **Post date:** [June 25, 2021, 6:49pm UTC](https://connective.celigo.com/t/i-am-unable-to-use-the-formula-text-in-the-additional-search-criteria/1089/5 "2021-06-25T18:49:32Z")
Hi @marlshanthana, The product manager indicated it has been prioritized for an upcoming release. Thanks, Kate ---
**Author:** ![gabrielburgener](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/gabrielburgener/32/4445_2.png) [@gabrielburgener](https://connective.celigo.com/u/gabrielburgener)\ **Post date:** [November 21, 2021, 7:29pm UTC](https://connective.celigo.com/t/i-am-unable-to-use-the-formula-text-in-the-additional-search-criteria/1089/6 "2021-11-21T19:29:36Z")
Hello Kate, are there any updates on this one? Best regards, Gabriel ---
**Author:** ![akhileshgoyal](https://avatars.discourse-cdn.com/v4/letter/a/7c8e57/32.png) [@akhileshgoyal](https://connective.celigo.com/u/akhileshgoyal)\ **Post date:** [November 22, 2021, 6:12am UTC](https://connective.celigo.com/t/i-am-unable-to-use-the-formula-text-in-the-additional-search-criteria/1089/7 "2021-11-22T06:12:57Z")
This issue has been resolved in the last release. Now, you should see an additional input field(see screenshot below) to provide your formula. ![5301043caa20740200000001-bcd000531e3c4c30b4e32885895a4476.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/48e0096461ae298a3a15cb2abe3126b5f55cd258.png) Regards, Akhilesh Goyal ---
**Author:** ![katelarson](https://avatars.discourse-cdn.com/v4/letter/k/91b2a8/32.png) [@katelarson](https://connective.celigo.com/u/katelarson)\ **Post date:** [November 22, 2021, 4:37pm UTC](https://connective.celigo.com/t/i-am-unable-to-use-the-formula-text-in-the-additional-search-criteria/1089/8 "2021-11-22T16:37:44Z")
Hello @gabrielburgener, @marlshanthana, and @marcreid - I'm tagging you all just to ensure you are notified that this issue was resolved in our last release. (See official comment pinned to the top of this post.) Thanks again, Renuka, for reporting this issue! -Kate ---
**Author:** ![jasonmailey](https://avatars.discourse-cdn.com/v4/letter/j/e274bd/32.png) [@jasonmailey](https://connective.celigo.com/u/jasonmailey)\ **Post date:** [August 25, 2022, 12:44pm UTC](https://connective.celigo.com/t/i-am-unable-to-use-the-formula-text-in-the-additional-search-criteria/1089/9 "2022-08-25T12:44:23Z")
I'm having trouble making this work. Using dynamic lookup search on vendors: formula(text): {{ALTNAME}} is {{supplier.name}} Value at supplier.name on incoming data is present. Error: An nlobjSearchFilter contains invalid search criteria: formulatext:.