Help

Re: Determine if task has upcoming due date

563 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Gabriel_Giannet
4 - Data Explorer
4 - Data Explorer

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.
image
Capture

3 Replies 3
Office_Manager
6 - Interface Innovator
6 - Interface Innovator

Hi 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"
)
Gabriel_Giannet
4 - Data Explorer
4 - Data Explorer

WOW thanks so much! :grinning: