May 14, 2023 07:43 PM
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! Go to Solution.
May 15, 2023 12:26 AM
May 14, 2023 07:54 PM
What kind of things that you want to send ? and can you elaborate more with example about the difference in attempt 1 / 2/ 3
May 14, 2023 08:04 PM
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)
May 15, 2023 12:26 AM
May 16, 2023 06:04 PM
This totally works! Thank you so much ♥️