Help

FORMULA FIND()

Topic Labels: Formulas
Solved
Jump to Solution
546 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Mary
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
RdMedia_srl
7 - App Architect
7 - App Architect

Hi Mary 

try this formula 

 

 

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

 

This should be the output
 
Schermata 2024-02-14 alle 16.51.40.png
Best

Rodolfo - RdMedia

See Solution in Thread

3 Replies 3
TheTimeSavingCo
18 - Pluto
18 - Pluto

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"
)

 

Screenshot 2024-02-15 at 12.00.30 AM.png


Link to base

RdMedia_srl
7 - App Architect
7 - App Architect

Hi Mary 

try this formula 

 

 

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

 

This should be the output
 
Schermata 2024-02-14 alle 16.51.40.png
Best

Rodolfo - RdMedia
Mary
5 - Automation Enthusiast
5 - Automation Enthusiast

MERCI 😍