DATEADD formula based on variations from two other columns

In order to make it easier to grok, I would have individual fields for each type of date you need to calculate. You're probably going to want to use AND() and OR() statements with your IF() statements to figure out the logic you need. For example, for assign due date if the channel is email and the send size is large, your IF() statement might start like this: IF(AND({Channel}='Email',{Send Size}='Large'),DATEADD({Launch Date},-12,'days',[Here you would list alternatives or nest IF() statements])

You can use Airtable's formula feature to calculate the date based on your specific conditions. Here's a step-by-step guide on how to create these formulas for each date field:

1. Create a new table with the following fields:

   • Channel (single select: Email, Push, Banner)
   • Send Size (single select: Large, Small)
   • Launch Date (date field)
   • Assign Due Date (formula field)
   • Developer Due Date (formula field)
   • QA Due Date (formula field)
   • Approval Due Date (formula field)

2. Click on the "Assign Due Date" field, then click "Customize field type." Choose the "Formula" field type. Enter the following formula:
   
   

3. Click on the "Developer Due Date" field, then click "Customize field type." Choose the "Formula" field type. Enter the following formula:

4. Click on the "QA Due Date" field, then click "Customize field type." Choose the "Formula" field type. Enter the following formula:

5. Click on the "Approval Due Date" field, then click "Customize field type." Choose the "Formula" field type. Enter the following formula:

Now you have formulas in each date field that calculate the due dates based on the Channel and Send Size. The due dates will be automatically calculated as you input different Channels, Send Sizes, and Launch Date values. Note that this solution only covers the two cases you provided. You can add more nested IF statements following the same pattern if you have more possibilities.

Let me know if you have any questions or need further assistance!

@joshsorenson The solution works but for Approval Due Date when I use "N/A" it breaks the date formatting in the field. Under the formatting tab it says "Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date."