Hi everyone!
Kindda urgent. 
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.
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:
Status Column = Priority Levels
Date Column = Deadline Date
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:
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!
Thank you so much! I really appreciate it.
Hi,
How about if i exclude the weekend?
