Hey, what kind of Switch is that ..!?
You're repeating the switching field {Advertising Plan} on every option.
I guess even the formula parser is getting cross-eyed. 👀
Hi @Penny_Bell ,
It's easier to read like this, with line breaks and tabs for clarity.
Is 8 weeks 55 days right?
IF(
AND({Advertising Plan}, {Live Date}),
SWITCH(
{Advertising Plan},
"2 weeks", DATEADD({Live Date}, 13, 'days'),
"4 weeks", DATEADD({Live Date}, 27, 'days'),
"8 weeks", DATEADD({Live Date}, 55, 'days'),
"52 weeks", DATEADD({Live Date}, 364, 'days')
)
)
Hey, what kind of Switch is that ..!?
You're repeating the switching field {Advertising Plan} on every option.
I guess even the formula parser is getting cross-eyed. 👀
Yes, I need a switch on every option. If there is a better way to do it please let me know.
Basically, the Advertising Plan needs to be one day less than the specific number of weeks. So 2 weeks is actually 14 days, etc etc
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.