Formula CountIFS Not Returning Expected Results


I'm attempting to utilize the following formula within a cell: =COUNTIFS([1st: Status]@row:[31st: Status]@row, "Completed"). However, it currently displays a value of 0, despite having more occurrences than that.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!