# Re: Why is my formula shortened by Airtable?

Solved
1260 1
cancel
Showing results for
Did you mean:
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
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'
)``````

4 Replies 4
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'
)``````

18 - Pluto

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

5 - Automation Enthusiast

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