IF and DATEADD Forumlas together

[Hazel_Moran]

Hello,

I am trying to get repeating tasks to work based on their regularity (Daily, Weekly, Monthly) with the IF and DATEADD formula used together. Here is what I have tried:

Can anyone suggest where I am going wrong?

[augmented]

Hi Hazel. Well, it looks like your formula needs another closing right paren. If you want to add in the capabilities for monthly & daily, then add another IF… right after “7, ‘days’)”

,IF(Repeating=‘Monthly’…

[Hazel_Moran]

Thanks for your help, unfortunately it is still not working for me… this is what I have now as the basic weekly formula:

IF(Repeating = ‘Weekly’, DATEADD ({Due date} ,7,‘days’))

Perhaps I am going wrong elsewhere…

[Kamille_Parks]

This is a better use case for SWITCH() than it is for a nested IF() statement since you’re comparing the same thing over and over.

SWITCH(
   {Repeating},
   "Daily",
   DATEADD({Due date}, 1, "days"),
   "Weekly",
   DATEADD({Due date}, 1, "week"),
   "Monthly",
   DATEADD({Due date}, 1, "month"),
)

[augmented]

So I just recreated everything to match what you’re doing and it works for me. One thing that stands out to me that I don’t understand is that green circle in the formula window of the screen snip you shared.

You clearly had formula in there before that worked, as I can see the values in lower rows. Is there more of the formula in the window that we can’t see?

I’m stumped.

[Kamille_Parks · Accepted solution]

More or less the same formula as above, but made more efficient:

IF(
   AND({Repeating}, {Due date}),
   DATEADD(
      {Due date},
      1,
      SWITCH(
         {Repeating},
         "Daily", "days"
         "Weekly", "weeks",
         "Monthly", "months"
      )
   )
)

[Hazel_Moran]

Yes, you are right, I have the DATEADD part working but not the Repeating… All sorted now - thank you for all your suggestions!

[Hazel_Moran]

This worked like a dream - thank you so much!