Hi! I’m trying to create an automation to push a button every first monday of every month (example: 2th of November, 7 of December, etc) @Alice_Ly was super helpful and created this formula: Formula name: “First Monday of Every Month” Sequence(ToDate(Concatenate(Month(Today()),"-",1,"-",Year(Tod…

Special thanks to @Ben_Lee :raised_hands:

Hi @Hector_Reyes :slight_smile: I’ve seen this post that maybe can help you :slight_smile: It’s a basic concept but it should do the job :grin: [image] Why is Month kind of ignored in Coda Suggestion Box @Marko_Petrovic yes I agree there is a lot that could be done with…

As I stated in topic that @Mario linked, I really wished Coda had some more support for operations with months (both automation and formulas). As is we are forced to write some complex formulas for some pretty basic stuff (like my example of counting number of months between 2 dates or OP-s formula …

Yes @Marko_Petrovic , dates and times still have their speed bumps. We hear you on this, it’s just not part of a project at the moment, but we will look into this at some point. I also brought this up in a few other channels and there were a few more solutions posted… From @Saul_Garcia and using a …

Here’s a more concise and performant way (one calculation instead of seven checks) to calculate first Monday of the month relative to the date. Use .DateTimeTruncate("month") to get the first day of month, Figure out how many days are there till the next Monday using this formula: thisRow.[First …

@Ben_Lee Thank you for the answer and some potential solutions. I hope date/time formulas, especially concerning months, will be improved at some point like many aspects of Coda are every month, it will make our everyday life much easier :slight_smile: Also I have to thank @Paul_Danyliuk for his co…

If we just need to trigger an action the first Monday of the month (vs. enumerate all first-Mondays), isn’t it as simple as adding a Time-Based Rule to run on Monday and then a check if it is the first 7 days of the month: [image] (Still learning my way around, so may be missing something obvious…

hi @Tim_Burns1 , thanks for the suggestion. I guess you tried it out? It is indeed an easy set-up, done in a few minutes. My steps in line with your suggestion: put the day on today (it is Saturday for me) put the time on 11h AM (the nearest full hour in my time zone) ask for True() via IF using: …

How would this formula change if you were trying to create an automation to push a button every third monday of every month?

Hello @Paloma_Garcia , I would set it up completely different. Have the automation trigger every Monday Set a condition: today().day() >=15 && today().day()<=21 This day range always includes the 3rd Monday of any month, therefore only triggers only on one Monday every month. Going back to the …

Automate action every first Monday of month?

Mario November 11, 2020, 9:52pm 3

Hi @Hector_Reyes
I’ve seen this post that maybe can help you
It’s a basic concept but it should do the job

Thanks to @Johg_Ananda

Topic		Replies	Views
Repeating Events the same Monday of the month	3	945	January 7, 2023
Set Automation to run every 15 days	1	556	August 16, 2022
Why is Month kind of ignored in Coda Product Feedback	8	1537	November 12, 2020
Beginning of the month formula	5	2423	October 29, 2020
Is there a formula for first Tuesday of the month?	4	743	October 20, 2021

Automate action every first Monday of month?

Related topics