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
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
)
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.