Help

Formula question - concatenate

677 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Gardner1
7 - App Architect
7 - App Architect

Hello-

I am trying to add in a concatenate formula in here that when the drop down is selected as in APPROVED FOR PRE-PRO, THE STATUS IN FORMULA WILL READ PRE-PRO-APPROVED FOR PRE-PRO not just PRE-PRO.

SWITCH(

{PRE-PRESS STATUS},

‘APPROVED FOR PRE-PRO’, ‘PRE-PRO’,

‘’, SWITCH(

{FINAL PROOFING STATUS},

‘APPROVED FOR PRE-PRESS’, ‘PRE-PRESS’,

‘’, SWITCH(

{SUBMITTAL STATUS},

‘APPROVED FOR FINAL PROOFING’, ‘FINAL PROOFING’,

‘’, SWITCH(

{DESIGN STATUS},

'APPROVED FOR SUBMITTAL', 'SUBMITTAL',

'', SWITCH(

  {PROJECT STATUS},

  'APPROVED FOR DESIGN', 'DESIGN',

  ''

),

'DESIGN'

),

‘SUBMITTAL’

),

‘FINAL PROOFING’

),

‘PRE-PRESS’

)

1 Reply 1

Hi @Scott_Gardner1,
Maybe its the formatting from your paste into the forum but this Switch formula looks a little odd.

To answer your question, You probably just need to change this part
SWITCH(

{PRE-PRESS STATUS},

‘APPROVED FOR PRE-PRO’, ‘PRE-PRO’,

‘’, SWITCH(

To this:

SWITCH(

{PRE-PRESS STATUS},

'APPROVED FOR PRE-PRO', 'PRE-PRO-APPROVED',

'', SWITCH(