Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Several formulas in one field

Topic Labels: Formulas
Solved
Jump to Solution
1916 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