Conditional formula based on selection

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

Welcome Jen,

You seem to be proposing us a game of “find the differences” :slight_smile:

‘week’ should be ‘weeks’
1o is not a number

(The good thing is that you don’t have any more options to consider… :smile: )

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.