Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 17, 2023 02:28 AM - edited Oct 23, 2023 12:15 AM
Oct 17, 2023 06:08 PM
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. 👀
Oct 17, 2023 06:16 PM
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')
)
)
Oct 23, 2023 12:15 AM
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