Control text from a list

[Cristiano_Volpi]

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

[Dimitris_Goudis]

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

[Cristiano_Volpi]

In short yes 🙂

thank you very much in advance! 

[Dimitris_Goudis · Accepted solution]

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 

[Cristiano_Volpi]

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.