Required vs. Completed formula help
I think this is an easy one but my brain is not firing correctly today.
I need a formula which will compare how many tasks in the "Required Milestones: OT" have actually been completed. So I have my formula for the required tasks =COUNTIF([Required_Milestones]:[Required_Milestones], "OT") but how do I get it to look at the status column for "Complete" to tell me how many of these have been completed.
Help Article Resources
Check out the Formula Handbook template!