Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Conditional formula based on selection

Topic Labels: Formulas
291 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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