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.

Conditional formula based on selection

Topic Labels: Formulas
922 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jen_R
4 - Data Explorer
4 - Data Explorer

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
Grunty
7 - App Architect
7 - App Architect

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