Set Priority Status Based on Date with Automations

Hi everyone!

Kindda urgent. :slight_smile:

What formula should I use to set a priority if there is only “specific” number of days remaining before the deadline? I wanted to do 3 levels of prioritys. high, medium and low.
I wanted to have the priority column be based on the timeline column i set.
What column should I need to create?
What priority formula should I use?

Thansk for all the help.

@TJ_S

Hello and welcome to the Monday community!

There are lots of different ways to accomplish this but based on your use case, here is the simplest way I can think of:

Minimum Columns:

Status Column = Priority Levels
Date Column = Deadline Date

Automation

When date arrives and at status is something change it to something else

You will want to set up 2-3 automations like this for your priority levels. For example, here is one that sets the priority level when only 1 day is left before the deadline:


The “1 day before” can be changed however you need, so if you want to set High to 3 days before, Medium to 6 days before etc. Its fully customizable.

I said 2-3 automations, because you could just set every new item to be default Low Priority and then only have the priority change once the date gets closer.

Hope this helps!

1 Like

Thank you so much! I really appreciate it.

1 Like

Hi,

How about if i exclude the weekend?

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