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!