Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 14, 2021 06:51 PM
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)
Jun 14, 2021 07:33 PM
IF(
{Produtos} != "Continuar",
CONCATENATE(Products," ", "R$", Value)
)
Jun 14, 2021 07:43 PM
It’s giving an error :thinking:
Jun 14, 2021 08:14 PM
Re-type the quotes around the R$
. They’re “curly” quotes and formulas only accept straight quotes.
Jun 16, 2021 07:12 PM
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?
Jun 16, 2021 07:44 PM
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
IF(
{Produtos} != "Continuar",
CONCATENATE(Products," ", "R$", Value),
"something else"
)