Skip to main content

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’


)

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(

Reply


Terms & Conditions