Skip to main content

Problem with Switch formula

  • January 9, 2023
  • 1 reply
  • 1 view
T
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'))

 

    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.

    T
    1 person likes this
    • T
      Tobin_Perry

    Reply


    Most helpful members this week

    Terms & Conditions