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
Mkosek,
What Chris and I were trying to explain is that you don't need to have a long equation to evaluate the priority value if that value is the number of days you are adding.
i.e. If Priority = 1, add 1.
So you don't need a long equation of "If" statements, rather you can insert the [Priority] directly into the equation.
+Days([Priority])
Now to take it a step further you want to have only weekdays listed as the result. So we use the formula;
WeekdayAdd (Date d, Number n)
Keep in mind that your "Date" needs to be just a date and not date/time.
So I use the conversion of "ToDate" to take the time our of the date/time field of [Date Created] to only return the date;
ToDate([Date Created])
Combining all of the above you will have a one line formula that will dynamically update based on date created and priority, and returning a weekday value.
If you put that line, and only that line in your formula date field of [Due Date] I feel confident you will get the result you are looking for.
I apologize for the confusion that we might have brought to the original question.
What Chris and I were trying to explain is that you don't need to have a long equation to evaluate the priority value if that value is the number of days you are adding.
i.e. If Priority = 1, add 1.
So you don't need a long equation of "If" statements, rather you can insert the [Priority] directly into the equation.
+Days([Priority])
Now to take it a step further you want to have only weekdays listed as the result. So we use the formula;
WeekdayAdd (Date d, Number n)
Keep in mind that your "Date" needs to be just a date and not date/time.
So I use the conversion of "ToDate" to take the time our of the date/time field of [Date Created] to only return the date;
ToDate([Date Created])
Combining all of the above you will have a one line formula that will dynamically update based on date created and priority, and returning a weekday value.
WeekdayAdd( ToDate([Date Created]), [Priority])
If you put that line, and only that line in your formula date field of [Due Date] I feel confident you will get the result you are looking for.
I apologize for the confusion that we might have brought to the original question.