Help

SWITCH formula with DATEADD

Topic Labels: Formulas
205 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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’)
)

Labels