Metric Sheet Countifs formula is not quite right - what am I doing wrong?

These first two formulas work in this Metric Sheet.

=COUNTIF({Level-ones}, $[Primary Column]@row)

=COUNTIF({Status}, [Column5]$23)

As seen by the returned values 66 and 21.

When trying to combine as COUNTIFS, it gives unparseable reply for the following formula.

=COUNTIFS({Level-ones}, $[Primary Column]@row1, {Status}, [Column3]$23)

(I also tried =COUNTIFS({Level-ones}, $[Primary Column]@row, {Status}, [Column]$23) variations and without $)

My data source for these columns:

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!