Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Problem with Switch formula

811 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.