Countif

I don't know if I should use the Countif or Countifs but either way, my formula isn't working for me. I'm trying to count the Progress Status of each Team member's project.

So my Source file is "Masterfile" and my column is "Progress" and each status is "Not Started" or "In Progess" or "Completed"

When I tried to do the formula:

=COUNTIFS({Masterfile HR Intake Project Sheet Range 5}, Variables@row, "Not Started")

I get error INCORRECT ARGUMENT

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!