Question on Metric Sheets and COUNTIFS formula


I was working on a metric sheet and it was working perfectly but then all of a sudden my whole table went into error - not sure what I did!

Here is my formula:

=COUNTIFS({DPM Programme FY24 Workstream}, [Primary Column]@row, {DPM Programme FY24 Status}, [Column2]$2)

And here is my table:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!