Help

Several formulas in one field

Topic Labels: Formulas
Solved
Jump to Solution
857 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Isabel_Sanchez
4 - Data Explorer
4 - Data Explorer

Hi, im just beggining my learning journey with Airtable and im trying to configure a field wchich should pick a value from a switch and also if it finds an option on a multiple selection field then add a number to the result.

This is what i ve been trying so far, but it doesn´t work.

SWITCH({Clases a la semana},1,35,2,65,3,90,4,110,5,130,6,150,7,170,8,190,9,205,10,220,11,230,12,240) & IF(FIND(“Tips Club”, Horario), +40,0)

Thank you in advance

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

You almost have it. You just need to change & to +. I also find a multi-line format easier to read.


SWITCH( {Clases a la semana},
  1,35,
  2,65,
  3,90,
  4,110,
  5,130,
  6,150,
  7,170,
  8,190,
  9,205,
  10,220,
  11,230,
  12,240
) 
+
IF(
  FIND("Tips Club", Horario), 
  40,0
)

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

You almost have it. You just need to change & to +. I also find a multi-line format easier to read.


SWITCH( {Clases a la semana},
  1,35,
  2,65,
  3,90,
  4,110,
  5,130,
  6,150,
  7,170,
  8,190,
  9,205,
  10,220,
  11,230,
  12,240
) 
+
IF(
  FIND("Tips Club", Horario), 
  40,0
)

Nice!!! it works perfectly.

Thank you very much