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
Impossible to set alerts based on a formula value Special workflows & use cases integrations , automations , notifications	5	1517	July 23, 2022
Formula column as Due Date Special workflows & use cases formula	0	1123	November 7, 2022
Send notifications via a Formula column or convert formula to date format Platform discussions integrations , automations , columns , formula	3	2186	September 12, 2022
Change status if date column is within xx months Platform discussions automations , date , status	2	885	November 2, 2023
Automations that check date fields or formula fields Platform discussions automations , notifications , formula	2	1109	April 1, 2023

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?