Skip to main content

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” 🙂


‘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


Terms & Conditions