Skip to main content

Formula question - concatenate

  • August 11, 2022
  • 1 reply
  • 15 views
Scott_Gardner1
Forum|alt.badge.img+15

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

    V
    Forum|alt.badge.img+16
    • Vivid-Squid
    • Inspiring
    • 529 replies
    • August 11, 2022

    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(


    Terms & ConditionsAccessibility statement