Should be simple CountIF

kyle.huston

Any help on why this isn't working would be great.

Paul Newcome

Try putting quotes around "Complete".

Genevieve P.

Hiya @kyle.huston!

To add on to Paul's correct answer (text in formulas needs to be wrapped in quotes), it looks like your formula is searching for specific values that you already have typed into your metric sheet.

You can reference the cells to the left of your formula instead of typing in something manually. For example:

=COUNTIF({Project Plan Range 3}, [Column Name]@row)

The [Column Name]@row would be the cell where your word "Complete" is found. Then you can simply drag that formula down and it will automatically reference "In Progress" and "Not Started" without you needing to create three formulas.

Here's a Help Article with more information: Create a Cell or Column Reference in a Formula

Cheers,

Genevieve