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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!