Help

SWITCH formula with DATEADD

Topic Labels: Formulas
674 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kirstie_Mcconne
4 - Data Explorer
4 - Data Explorer

Hi, I need it to work out,

IF “Recycled” is “Weekly”, make the date in “Next Post” 7 days after “Post Date”.
IF “Recycled” is “Every Two Weeks”, make the date in “Next Post” 14 days after “Post Date”.
IF “Recycled” is “Every Three Weeks”, make the date in “Next Post” 21 days after “Post Date”.
IF “Recycled” is “Blank”, leave “Next Post” blank.

This is the formula I am trying but it is returning an error:

SWITCH({Recycle}, “Weekly”, DATEADD({Post Date}, 7, ‘days’),
“Every Two Weeks”, DATEADD({Post Date}, 14, ‘days’),
“Every Three Weeks”, DATEADD({Post Date}, 21, ‘days’), BLANK())

Can anyone see what I’m doing wrong?
Screen Shot 2021-05-22 at 11.44.28 am

1 Reply 1
Kirstie_Mcconne
4 - Data Explorer
4 - Data Explorer

Ohhh… I got it!
For anyone trying to figure out something similar… the formula was:

SWITCH(
Recycle,
‘Weekly’, DATEADD({Post Date}, 7, ‘days’),
‘Every Two Weeks’, DATEADD({Post Date}, 14, ‘days’),
‘Every Three Weeks’, DATEADD({Post Date}, 21, ‘days’)
)