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
Solved
FORMULA FIND()
+4Best answer by RdMedia_srl
Hi Mary
try this formula
IF(
FIND("PAYMENT", Label), "VER", ""
&
IF(FIND("PRLV SEPA", Label), "VER", ""
)
)
This should be the output
Best
+31Hi 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"
)
+10Hi Mary
try this formula
IF(
FIND("PAYMENT", Label), "VER", ""
&
IF(FIND("PRLV SEPA", Label), "VER", ""
)
)
This should be the output
Best
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.