Hi All,
I am trying to figure out if a particular task has an upcming due date by seeing if a particular date field falls within 4 weeks from today.
I have written the following formula:
IF(AND({Milestone_Current_Due_Date} <= DATEADD(TODAY(), 1, ‘month’)),{Milestone Status}!=‘Completed’, “Upcoming Due Date”)
But as you can tell from this screenshot it does not seem to operating correctly, saying some tasks have an upcming due date that is not within 4 weeks.
+8Hi Gabriel,
Looking at your formula, you have Milestone Status to equal Completed. Your screenshot shows the status as Incomplete. I think the formula needs to say Incomplete or you need to select Complete in Milestone Status to keep your formula as is.
+27Hi Gabriel,
Looking at your formula, you have Milestone Status to equal Completed. Your screenshot shows the status as Incomplete. I think the formula needs to say Incomplete or you need to select Complete in Milestone Status to keep your formula as is.
The formula actuatally is using !=, which means “do not equal”, so that isn’t the issue. The closing parenthesis for the AND() statement is in the wrong place:
IF(
AND(
{Milestone_Current_Due_Date} <= DATEADD(TODAY(), 1, "month"),
{Milestone Status}!="Completed"
),
"Upcoming Due Date"
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.