Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Getting an #error with a swich function

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

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