Formula Help

Minni
Minni ✭✭✭
edited 06/26/23 in Formulas and Functions

I am for some reason having an issue getting function to calculate correctly. I need to pull the count for just active projects in one column but it is calculating all of them. There should only be 143. Can anyone help with this?

=SUMIF([Project Phase]:[Project Phase], "Active")

=COUNTIF([Project Phase]:[Project Phase], "Active")

=COUNTIFS([Project Phase]:[Project Phase], "Active")

Minni Florence

Senior Project Coordinator

Industrial Properties Construction

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!