- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 09, 2023 07:14 PM
I have the followign problem.
In a cell I have a list of tags, separated by a comma, i.e.
Apple, Banana, Grape
Then I have a control list of allowed tags, that is
Apple, Banana, Strawberry
So, the formula should eliminate the tags Grape is it is a now allowed tags, and return this resul
Apple, Banana
Any ideas on how to obtain it?
Thank you very much in advance
Regards
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 16, 2023 01:06 AM
Thanks @Cristiano_Volpi,
Formulas are not able to do that by covering all potential scenarios of values in text fields. To achieve your goal based on my experience I would recommend one of the following options:
- Use Zapier or make.com creating an automation that will analyze text and it will return the values you need
- Use an automation with a script that will do this process inside the Airtable.
Does it make sense? For any kind of question please do not hesitate to post.
Yours sincerely,
Dimitris Goudis
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 16, 2023 12:50 AM
Hey @Cristiano_Volpi,
Is your actual problem the need for a formula that will recognize the common tags in those 2 fields and it will return only the commons?
Thanks
Yours sincerely,
Dimitris Goudis
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 16, 2023 12:59 AM
In short yes 🙂
thank you very much in advance!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 16, 2023 01:06 AM
Thanks @Cristiano_Volpi,
Formulas are not able to do that by covering all potential scenarios of values in text fields. To achieve your goal based on my experience I would recommend one of the following options:
- Use Zapier or make.com creating an automation that will analyze text and it will return the values you need
- Use an automation with a script that will do this process inside the Airtable.
Does it make sense? For any kind of question please do not hesitate to post.
Yours sincerely,
Dimitris Goudis
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 27, 2023 07:20 PM
Dear Dimitris,
thank you very much for suggestion, at the end I have decided to use Zapier with ChatGPT 100% no code 🙂
So far seems that AI can handle the task very well.
