Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Aug 11, 2022 08:59 AM
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’
)
Aug 11, 2022 09:24 AM
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(