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.
Is not [Priority] a formula field you created that has contains some 'x' number of days?
If so, then that is the parameter you pass to the Days() function. That makes it more dynamic and no need to have redundant lines of code.