Skip to main content

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'
)

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

 

That worked! Thank you.

Terms & ConditionsAccessibility statement