due date formula based on priority ...help
[Priority]=1,[Due Date] Today() + Days(1) [Priority]=2,[Due Date] Today() + Days(2) [Priority]=3,[Due Date] Today() + Days(3) [Priority]=4,[Due Date] Today() + Days(4) [Priority]=5,[Due Date] Tod...
Forum Discussion
[the new date] =
[Due Date] Today() + Days([Priority])
Due date is a formula date field I created to automatically populate based on whatever priority the project is set at.
So in this case it is for quoting purposes. If our customer wants the quote for the job returned as soon as possible, I would set priority to 1.
That will automatically populate the DUE DATE field today + I day. This way everyone in our team knows the project must be completed by tomorrow (Next, I will setup notifications/subscriptions if the project is past due).