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 😍

Terms & ConditionsAccessibility statement