Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How not to concatenate a particular product from a list

Topic Labels: Formulas
284 5
Showing results for 
Search instead for 
Did you mean: 

hello guys!.

I have an apparently simple situation to solve, but I’m still not used to the airtable formulas. basically I have a list of products and a product with the name “continue” which is an option that follows the flow of the system I am integrating with airtable.

All products contact the Values ​​column. however I wanted the product “continue” not to concatenate. is it possible to insert this condition in the formula?

The formula I’m using is: CONCATENATE(Products," ", “R$”, Value)


5 Replies 5
   {Produtos} != "Continuar",
   CONCATENATE(Products," ", "R$", Value)

It’s giving an error :thinking:


Re-type the quotes around the R$. They’re “curly” quotes and formulas only accept straight quotes.

now it worked, but I would like the name to continue in the cell, but instead the cell is blank. what would I have to modify in the formula?

Not sure what you mean by name continuing, but if you want something else to show when Produtos isn’t continuarr, you’d just add a third argument to the IF statement

   {Produtos} != "Continuar",
   CONCATENATE(Products," ", "R$", Value),
   "something else"