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])
make [the new date] a formula date field and put the code below into it.
Let us know how it goes.
That should probably go like this instead:
[the new date] =
Today()+Days([Priority])
I'm not certain what [Due Date] is supposed to be.
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).
