Help with Metric sheet


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.
    Genevieve P. Employee Admin

    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))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!