Help with Metric sheet

Ileana Stover

Hello,

I created this metric sheet to get totals for overall performance but I can't get the totals to populate from the sheet that is being referenced. Not sure what I am doing wrong,

Genevieve P.

Hi @Ileana Stover

This may have to do with the fact your numbers are in the Primary Column, so it's read a bit differently. Instead of using CONTAINS, what about just seeing if the column has that Metric in it, like this:

=COUNTIF({Manager Feedback template Anthony Range 1}, Metric@row)

If that doesn't work, try taking the VALUE of the Metric cell, converting it to a number:

=COUNTIF({Manager Feedback template Anthony Range 1}, VALUE(Metric@row))

Cheers!

Genevieve