Lookup or Formula Field in a Form

[Isabel_Sanchez]

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

[kuovonne · Accepted solution]

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
)

[Isabel_Sanchez]

kuovonne:

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