Formula Issues

[ColtE8]

Hey everyone! I'm having some issues figuring this formula out.

There are multiple [issue types] but I am only looking for one specifically (Milestone). I also only want it to pull in milestones that are open. The end result needs to show me milestones that are open but past due. The current formula shows past due, but for any milestone that is open and closed. I can't figure out how to input the open part into this!

if([Issue Type] = 'Milestone' and ([Current Estimated Completion Date] - today() < 0), 1,0) as Milestone_Past_Due,

I'm not only learning visuals but I've never really coded in the past either so, drinking from a firehose here. Any tips are appreciated.

[rwunderlich · Accepted solution]

I'm assuming there is something like a Status field that "Open" or "Closed"? If so, just add Status= as another condition.

if([Issue Type] = 'Milestone' and Status="Open" and ([Current Estimated Completion Date] - today() < 0), 1,0) as Milestone_Past_Due,

-Rob

[ColtE8]

Wow that was simple I was definitely over thinking this. Thank you!

[rwunderlich]

You're welcome. Don't forget to mark Accept as Solution. 

-Rob