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
that is my point, the priority value IS NOT the number of days I am adding
The number of days I am adding is based off the priority. Pretend I want to add 7 days to the [date created] if priority is 1. Would that change the formula you are proposing? I would think it would. it just so happens that priority 1 through 4 are the same value as the days I am needing to add. That is not the case for Priority 5-9
Priority 1 = +1 day
Priority 2 = +2 day
Priority 3 = +3 day
Priority 4 = +4 day
Priority 5 = +4 day
Priority 6 = +5 day
Priority 7 = +6 day
Priority 8 = +7 day
Priority 9 = +8 day
Priority 10 = +10 day
correct - to simplify the formula I thought about setting the priority to whatever value days I need added but that wont work for us.
I tried your formula above and I get the following syntax error
"Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets."