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 …

@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

Notify someone if date is within 2 months

Platform discussions

JCorrell (Jim - The Monday Man) December 16, 2021, 2:07pm 2

@PierreM

You can use this recipe template:

Then set the When portion to trigger 2 months before:

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

1 Like

Topic		Replies	Views
Automations that check date fields or formula fields Platform discussions automations , notifications , formula	2	1355	April 1, 2023
Is there a way to set up a date calculator between two date columns? Feature requests automations	1	1601	July 6, 2023
Send Reminder X Weekdays Before Due Date Feature requests automations , notifications	2	17	March 27, 2025
Automation: 10 month after “date column” if status is “something” notify “someone” Platform discussions automations	3	1542	November 11, 2021
Automation Function based on athe result of a formula field monday apps & integrations automations , formula , date	8	1508	July 14, 2025

Notify someone if date is within 2 months

Become part of our community groups

Can't find what you're looking for?

Can't find
what you need?

Notify someone if date is within 2 months

Related topics

Become part of our community groups

Can't find what you're looking for?

Can't findwhat you need?

Can't find
what you need?