Let's say I have 3 date columns namely Attempt #1, Attempt #2, and Attempt #3.
I want to send Attempt #1 on May 1, 2023 --- then I want Airtable to automatically compute the next follow-up date (which is after 3 days). But if it falls on a weekend, I want it to automatically add the nearest weekday date available. The same goes for attempt #3, I want Airtable to compute the next follow-up date based on the date indicated in attempt #2. Is this possible?
Solved
If formula in a date formula?
+3Best answer by TheTimeSavingCo
I'll be sending outreach emails.
For example, I want to send my first outreach email on May 4 (Attempt #1), which is Thursday. I want a formula that will automatically set the date when I should send attempt #2. But I only want the dates to be on weekdays and spaced every 3 days. So if my attempt #1 is Thursday, attempt #2 will be on Sunday, May 7. But since it falls on a weekend, I want the system to automatically change the attempt #2 date to Monday, May 8. The date for attempt #3 will be based on the date for attempt #2, so if it's May 8, attempt #3 should be on May 11. (I hope I was able to explain what I was hoping to do)
Perhaps try using WORKDAY()?
+1What kind of things that you want to send ? and can you elaborate more with example about the difference in attempt 1 / 2/ 3
+3What kind of things that you want to send ? and can you elaborate more with example about the difference in attempt 1 / 2/ 3
I'll be sending outreach emails.
For example, I want to send my first outreach email on May 4 (Attempt #1), which is Thursday. I want a formula that will automatically set the date when I should send attempt #2. But I only want the dates to be on weekdays and spaced every 3 days. So if my attempt #1 is Thursday, attempt #2 will be on Sunday, May 7. But since it falls on a weekend, I want the system to automatically change the attempt #2 date to Monday, May 8. The date for attempt #3 will be based on the date for attempt #2, so if it's May 8, attempt #3 should be on May 11. (I hope I was able to explain what I was hoping to do)
+31I'll be sending outreach emails.
For example, I want to send my first outreach email on May 4 (Attempt #1), which is Thursday. I want a formula that will automatically set the date when I should send attempt #2. But I only want the dates to be on weekdays and spaced every 3 days. So if my attempt #1 is Thursday, attempt #2 will be on Sunday, May 7. But since it falls on a weekend, I want the system to automatically change the attempt #2 date to Monday, May 8. The date for attempt #3 will be based on the date for attempt #2, so if it's May 8, attempt #3 should be on May 11. (I hope I was able to explain what I was hoping to do)
Perhaps try using WORKDAY()?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.