switch formula error

Forum|Forum|1 year ago
February 19, 2024
2 replies
13 views

+2

trischapman
New Participant

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'

)

+31

TheTimeSavingCo
Brainy
Forum|Forum|1 year ago
February 19, 2024

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