Specific Date range that will change a Priority column

[Jennifer_Biggs]

I am trying to automatically change a Priority column based on the Due Date field. So, for example, if the due date is within 3 days, the priority changes to High. If the due date is between 4 and 10 days, then the priority changes to Medium, and if the due date is greater than 10 days, then the priority changes to Low.

Any help or suggestions would be appreciated.

Thanks

[Melanie_Teh]

@Jennifer_Biggs

to achieve this and if you’re just requiring a non-editable Priority column, then a column with the formula below will suffice

breakdown of formula for you or anyone reading this post in future -
we are taking the date time difference i.e. duration between Due Date and Today and then categorizing the priority based on the result (i.e. date time difference) with a conditional formula of SwitchIf() (Note: If() can also be used as alternative).

The Duration column i added to demo doc is for demonstrative purposes to check formula is correct.

Please find demo doc below for your reference

if you’re requiring the ability to also have priority set manually (override functionality), youll need to add another Priority column and update the formula Priority column with a nested If/SwitchIf().
Something along the lines of this:

Hope this helps!

Cheers!
Mel