Notify someone if date is within 2 months

Hello,

I have a user requesting to be alerted when the date of any item is within 2 months. I’ve managed to make a filter for this by using an additionnal formula column and the DAYS() function(The filter show the columns where the formula result is less than 60).

However I don’t find any way to create an automation so the user gets notified when a new item is within 2 months. I wanted to use the “When a number is less than a value, notify someone” but my formula column is not available there. And I don’t find a way to do it directly with the date column.

@PierreM

You can use this recipe template:
image

Then set the When portion to trigger 2 months before:
image

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas: the SECRET Functions

1 Like

As simple as that! Thank you @JCorrell

Hi @PierreM :wave:

It look like this post Notify someone if date is within 2 months - #2 by JCorrell here might have answered your question, is that correct?

If so, please don’t forget to mark it as the solution so other users can easily find it, and to close this thread :slightly_smiling_face:
If not, feel free to ask any additional questions you have!

Best,
Dani

Hi again @PierreM

I hope the answers in this thread are useful!
As we haven’t had any updates here, I’m going to go ahead and mark this thread as solved.
This means that the thread will close in 7 days time :slightly_smiling_face:

If you have any additional questions or you feel your original query wasn’t resolved, please feel free to let us know and we’ll be happy to continue to assist!

Best,

Dani

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.