Skip to main content

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

 

 

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

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


In short yes 🙂

thank you very much in advance! 

In short yes 🙂

thank you very much in advance! 


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 

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.

Reply


Terms & Conditions