Help

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

Getting an #error with a swich function

126 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello, Any help here on this Error for a blank date?

WORKDAY(
{PRODUCT LAUNCH DATE},
SWITCH(
{TASK TYPE},
“BOOTH DESIGN”,-21,
“SHOWCASE VIDEO”,-21,
“SHOWCASE PHOTOGRAPHY”,-21,
“LIFESTYLE VIDEO”,-21,
“LIFESTYLE PHOTOGRAPHY”,-21,
“APPAREL”,-14,
“BACKLIT AD”,-14,
“ADS”,-14,
“SNAPCHAT ADS”,-14,
“PR MARKETING GRAPHICS”,-14,
“END SLATE”,-14,
“PIN”,-14,
“PRE ROLL AD”,-14,
“EMAIL BLAST”,-14,
“DISTRIBUTION ADS”,-14,
“PRINT AD”,-14,
“DIGITAL GRAPHIC”,-14,
“QUARTERLY DIGITAL SPEND AD”,-14,
“WEB ADS”,-14,
“RETAILER KIT”,-14,
“PRINT GRAPHIC”,-14,
“OTHER”,-14,
“GOOGLE DISPLAY ADS”,-14,
“TENSION BANNER”,-14,
“DIGITAL SCREEN GRAPHIC”,-14,
“COPY ONLY”,-7
))

1 Reply 1

Hi @Scott_Gardner1

Try this:

IF({Launch Date} = BLANK(),
  BLANK(),
  WORKDAY({Launch Date},
    SWITCH({Task Type},
      "Agree Spec",-21,
      "Develop",-14,
      "Document",-7
)))

I hope this helps!

Julian