Skip to main content

SWITCH() Function Suddenly Not Working?

  • June 12, 2019
  • 8 replies
  • 27 views

Forum|alt.badge.img+19

Ah! ALL of my fields that incorporate the SWITCH() function are suddenly returning “#ERROR!”. Is anyone else having this problem? It happened when I just created a new field using that formula as well…

8 replies

Forum|alt.badge.img+18
  • Inspiring
  • 1691 replies
  • June 12, 2019

Yep, my SWITCH() functions appear to be returning #ERROR! as well.

@Airtable


Angel_Claudio
Forum|alt.badge.img+6
  • New Participant
  • 4 replies
  • June 12, 2019

Yeah I’m getting the same error :grimacing:


  • New Participant
  • 2 replies
  • June 12, 2019

Hi there,

We are looking into this - if you haven’t already, can you email support@airtable.com?

Thanks!


  • New Participant
  • 1 reply
  • June 12, 2019

Yes! I was also getting an “#ERROR!” see screenshots below. I will also be emailing to support. Glad to know it’s not just me!


Forum|alt.badge.img+3
  • New Participant
  • 3 replies
  • June 12, 2019

Me too! hopefully they fix it soon.


Forum|alt.badge.img+3
  • Participating Frequently
  • 7 replies
  • June 12, 2019

Yes, me too. I sent a support request. Email on the way.


Forum|alt.badge.img+3
  • Participating Frequently
  • 7 replies
  • June 12, 2019

Yes, me too. I sent a support request. Email on the way.


Changed it to a nested IF function instead. Makes a very complex formula even more complex but it worked for my situation.


  • New Participant
  • 2 replies
  • June 13, 2019

Hi everyone, today we had a temporary issue that affected formulas using SWITCH.

We take unintended data consistency problems like this very seriously, and we’re sorry for any problems this may have caused. Shortly after it came to our attention, we corrected the underlying problem.

If you continue to experience problems please reach out to us via support@airtable.com.

Thanks!