Hello,

I have 1 single select field called “Status”.

This Status field has the following options:

• Awaiting Information (Outreach 1)
• Awaiting Information (Outreach 2)
• Awaiting Information (Outreach 3)
• On Hold

Each of these options has its own date field connected to an automation that date-stamps when the option is selected in Status.

• Outreach 1 Date
• Outreach 2 Date
• Outreach 3 Date
• On Hold Date

I need 1 formula that returns a date with the following considered:

• If Status = Awaiting Information (Outreach 1), add “2” business days to Outreach 1 Date.
• If Status = Awaiting Information (Outreach 2), add “2” business days to Outreach 2 Date.
• If Status = Awaiting Information (Outreach 3), add “3” business days to Outreach 3 Date.
• If Status = On Hold, add “30” business days to On Hold Date.

This is what I’ve tried so far with the first 3 dates conditions:

IF(Status=“Awaiting Response (Outreach 1)”,DATEADD({Outreach 1 Date},2,‘days’)) & IF(Status=“Awaiting Response (Outreach 2)”,DATEADD({Outreach 2 Date},2,‘days’)) & IF(Status=“Awaiting Response (Final Outreach)”,DATEADD({Outreach 3 Date},3,‘days’))

But it returns a string value (e.g., “2022-01-06T00:00:00.000Z”).

What is the easiest way to configure this formula with all of the necessary conditions while also returning the date in a universal format (e.g., MM-DD-YYYY) and using business days in the dateadd formula?

This would be used to connect to an automation that sends us a message when this field is today’s date so we know when to conduct an outreach.

Thanks!