Skip to main content

Problem with Switch formula

  • January 9, 2023
  • 1 reply
  • 1 view

Forum|alt.badge.img+7

Hi everyone,

I'm having trouble with this formula. Can you tell me what I'm missing?

It comes up blank.

Thank you!

SWITCH({Recurring Frequency},"daily", DATEADD({Date to work on it}, 1,'days'),"weekly", DATEADD({Date to work on it}, 1,'weeks'),"monthly", DATEADD({Date to work on it}, 1,'months'),"quarterly", DATEADD({Date to work on it}, 3,'months'))

 

1 reply

Matthew_Lanni
Forum|alt.badge.img+16

I would check that the capitalization is the same between your SWITCH expressions and what's in your {Recurring Frequency} field.


Reply