Help

Control text from a list

Topic Labels: Data Formulas
Solved
Jump to Solution
412 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Cristiano_Volpi
5 - Automation Enthusiast
5 - Automation Enthusiast

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

 

 

1 Solution

Accepted Solutions

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 

See Solution in Thread

4 Replies 4

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! 

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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.