switch formula error

[trischapman]

I have a project stage field that I need to convert into generalized phases. I have the below SWITCH formula and I cannot get it to save. All of the articles I have read have examples formatted this way - What is the issue?

SWITCH(

  {Project Stage},

   ’Discovery’, ’In Progress’,

   ’Planning’, ’In Progress’,

   ’Account Build/Import’, ’In Progress’,

   ’Execution/Migration Prepped’, ’In Progress’,

   ’Imported’, ’In Progress’,

   ’Import Prepped’, ’In Progress’,

   ’Complete - Migrated’, ’Complete’,

   ’Migrated/Monitoring’, ’Complete’,

   ’Project Closed’, ’Closed’,

   ’Pending'

)

[TheTimeSavingCo]

Ah, your quotes might be the issue here.  I converted them to ' and it seems to work now:

SWITCH(
  {Project Stage},
   'Discovery', 'In Progress',
   'Planning', 'In Progress',
   'Account Build/Import', 'In Progress',
   'Execution/Migration Prepped', 'In Progress',
   'Imported', 'In Progress',
   'Import Prepped', 'In Progress',
   'Complete - Migrated', 'Complete',
   'Migrated/Monitoring', 'Complete',
   'Project Closed', 'Closed',
   'Pending'
)

Link to base

[trischapman]

That worked! Thank you.