Help

switch formula error

Topic Labels: Formulas
666 2
cancel
Showing results for 
Search instead for 
Did you mean: 
trischapman
4 - Data Explorer
4 - Data Explorer

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

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

Screenshot 2024-02-20 at 6.53.03 AM.png

Screenshot 2024-02-20 at 6.52.54 AM.png

Link to base

 

trischapman
4 - Data Explorer
4 - Data Explorer

That worked! Thank you.