Is it possible to make an automation to send out an email every third Monday of the month? I was only able to find ways to send out the email every certain day or time of the month, but not a specific third weekday. Thank you!
Hi Callie, to do this I would create two automations:
- The first automation will run once a month, on the first day of the month, and it will create a new record with that day’s date (e.g. 1 May 2022)
- The second automation will trigger off of a record matching a condition, in this case, detecting whether it’s the third Monday of the month
DATEADD( Date, SWITCH( WEEKDAY(Date), 0, 15, 1, 14, 2, 20, 3, 19, 4, 18, 5, 17, 6, 16 ), "days" )
I’ve created a base with the automations and formula set up here. To view the setup (formulas, automations etc), duplicate the base by clicking the title of the base at the top of the screen, then the three horizontal dots on the right, and then the “Duplicate Base” button.
Thank you so much for replying so quickly, this was a big help!