Help

The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.

Problem with Switch formula

734 1
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Tobin_Perry
6 - Interface Innovator
6 - Interface Innovator
See Solution in Thread

‎Jan 09, 2023 07:21 AM

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'))

 

0 Kudos
Reply
1 Reply 1
Matthew_Lanni
7 - App Architect
7 - App Architect
See Solution in Thread

‎Jan 09, 2023 02:26 PM

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

Reply
Copyright © 2025 Khoros, LLC