Help

Why is my formula shortened by Airtable?

Topic Labels: IF Formula
Solved
Jump to Solution
1183 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Davoies
5 - Automation Enthusiast
5 - Automation Enthusiast

Why is my formula shortened by Airtable?

In my project, I want a point of contact assigned by province using the if formula below:

IF(Province="BC","Ashlee", 
IF(Province="AB","Karen"),
IF(Province="SK","Karen"),
IF(Province="MB","Karen"),
IF(Province="ON","Cody "),
IF(Province="QC","Ches"),
IF(Province="NU","Ches"),
IF(Province="YT","Ches"),
IF(Province="NT","Ches"),
IF(Province="NB","Leena"),
IF(Province="NS","Leena"),
IF(Province="NL","Leena"),
IF(Province="PE","Leena")
)

Could anyone tell me why AirTable only saved  the following and if there is anything missing to my formula for all the provinces to be included in the formula?
IF(Province="BC","Ashlee Larose", 
IF(Province="AB","Karen Ergus"))

Your time and knowledge are greatly appreciated.  Sonia

1 Solution

Accepted Solutions
Jason_Hill
6 - Interface Innovator
6 - Interface Innovator

I think something is amiss with your browser. It should not be cut off. I'll take the time to mention the "SWITCH" function. It's nice to use instead of "IF". It's a bit shorter. Below is a short example.

SWITCH(
 {Province},
   'BC', 'Ashlee',
   'AB', 'Karen',
   'SK', 'Karen',
   'MB, 'Karen',
     'No Province'
)

 

See Solution in Thread

4 Replies 4
Jason_Hill
6 - Interface Innovator
6 - Interface Innovator

I think something is amiss with your browser. It should not be cut off. I'll take the time to mention the "SWITCH" function. It's nice to use instead of "IF". It's a bit shorter. Below is a short example.

SWITCH(
 {Province},
   'BC', 'Ashlee',
   'AB', 'Karen',
   'SK', 'Karen',
   'MB, 'Karen',
     'No Province'
)

 

It cuts off certain types of formulas that are invalid. Everything after the cutoff point was invalid.

Thank you Jason_Hill.  Not sure about my browser.  It's a work computer maintained by an IT company.  Regardless, your workaround formula is perfect for what I need and I will practice using SWITCH()  for the first time.  🐵  Thanks a bunch!

Sonia

Thank you for your time.  

Thank you ScottWorld for taking time to reply.  I will use a SWITCH () formula instead as suggested by @ScottWorld above.  🐵

Sonia