Skip to main content

Hello everyone,

I can't create a formula to find pieces of text in the "Libellé" (Text) field and transform them into a word.

Example :
IF “PAYMENT” or “PRLV SEPA” in the "Libellé" field
THEN “VER” in the formula field

Hi Mary!

Try:

 

IF(
FIND(
"Com CB",
{Long text field}
),
"Com CB"
) &
IF(
FIND(
"Remise CB",
{Long text field}
),
"Remise CB"
) &
IF(
OR(
FIND(
"PAYMENT",
{Long text field}
),
FIND(
"PRLV SEPA",
{Long text field}
)
),
"VER"
)

 


Link to base


Hi Mary 

try this formula 

 

 

IF(
FIND("PAYMENT", Label), "VER", ""
&
IF(FIND("PRLV SEPA", Label), "VER", ""
)
)

 

This should be the output
 
Best

MERCI 😍