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
Take out the parenthesis that have numbers inside them. Make it like this:
"[Date Created]+Days([Priority])". Sans quotes.
this ^^^ is the only line of code you need.
how does it know to add the certain amount of days then, don't I need to specify how many days I need added to the date created?
if it is a priority 5 project that I started today, I need the due date to show 10/30/2017. that reminds me, I am basing this off of a standard m-f work week (not to include sat & sun)