Automating Date Calculation & Reminders in Monday.com

Hello Monday.com Community,

I have a workflow challenge that I need help with regarding automatically filling a date column and setting reminders.

Use Case:

  • I have a pre-filled date column that serves as the starting reference.
  • A number column where I input the number of weeks.
  • I need to subtract the specified number of weeks from the pre-filled date and store the resulting date in another date column.
  • However, if I use a formula column to calculate this date, I won’t be able to set due date reminders, since formula-generated values cannot trigger notifications or automations.
    Challenges:

:small_blue_diamond: Formula Column Limitation: Since formula-generated dates are dynamic and not considered “real” date values, they cannot be used for reminders or automations.
:small_blue_diamond: Automating Date Population: I need a way to automatically populate an actual date column rather than just displaying it in a formula column.
:small_blue_diamond: Setting Due Date Reminders: The goal is to ensure reminders and automations can be triggered based on this calculated date.

You can do it with the Workflow Center. You’ll need to set your ‘notification date’ to ‘today’ and then ‘push’ (the push action lets you have the date post OR prior)

Bundle of thanks. Its very workable suggestion. Stay Happy

1 Like