Help

Problem with Switch formula

437 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Tobin_Perry
6 - Interface Innovator
6 - Interface Innovator

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 1
Matthew_Lanni
7 - App Architect
7 - App Architect

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