The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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"
)