COUNTIF FORMULA (3 Columns, 1 Column includes contact)

Hi All,

Need help with a formula!

I need a formula to summarize the following criteria. If Project Track = XX, and if Project Phase = XX and if Project Manager = X Person" what is the output?

My current formula, but it doesn't seem to be working. Is it due to the fact that the Project Manager filed is set to contact list?

=COUNTIFS([Project Track]:[Project Track], "T1-Concept", [Project Phase]:[Project Phase], "With Client", [Project Manager]:[Project Manager], "email address", [Project Track]:[Project Track], "T1-Concept", [Project Phase]:[Project Phase], "With Creative", [Project Manager]:[Project Manager], "email address")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!