
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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'))
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
