Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 24, 2021 07:03 PM
I cannot get this formula to work. Can someone help? I have a type field where you can select print or PDF. I need the start date to calculate a date either 4 weeks for print or 10 days for PDF. This is what I have:
SWITCH(
{Type},
‘print’, DATEADD({Start Date}}, 4, ‘week’),
‘PDF’, DATEADD({Start Date}}, 1o, ‘days’)
)
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 24, 2021 11:10 PM
Welcome Jen,
You seem to be proposing us a game of “find the differences” :slightly_smiling_face:
‘week’ should be ‘weeks’
1o is not a number
(The good thing is that you don’t have any more options to consider… :grinning_face_with_smiling_eyes: )
Reply