Question on Metric Sheets and COUNTIFS formula

SirJJ

Hello!

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:

heyjay

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

Your second arguement shows $2 which is not a function used in smartsheet.

SirJJ

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

@heyjay thank you - I have changed it this this previously but then get a #CIRCULAR REFERENCE error -not sure what that means as I have never come across it

Paul Newcome

@heyjay Yes. The $ is used to lock in a static cell reference and is perfectly valid within Smartsheet.

@SirJJ Double check your cross sheet references have not accidentally been adjusted. If one is referencing an entire column, the other should be referencing an entire column on the same sheet as the first.