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.

Reply


Terms & Conditions