Help

Conditional formula based on selection

Topic Labels: Formulas
814 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: )