averageif and summary fields working inconsistently


I'm using the averageif formula in the sheet summary. it works perfectly for the first line. I've literally copied and pasted it into another field in the summary, and it's no longer working. help?

I've tried under multiple names, validated the names/format by copying and pasting them, and confirmed the calculation is not correct. What am I missing?


  • Jaime M.
    Jaime M. ✭✭✭


    I haven't had good "luck" with sheet summaries displaying the correct data either and honestly their ability to refence the data in the sheet feels limited. I do see that each of your formulas reference "[Final Score]1" (same with HR Central Employee Name). What happens when you remove the "1" from each of these to reference the whole columns?

    Alternatively, I have had a lot of success setting up a separate metrics sheet where I can add helper columns in (such as Name), to do all my formulas. An example of mine is below:

    First column is Name (could be employee name for you), and all the other columns are a series of formulas I want to use that reference that Name column, along with different criteria. In my experience, this is much quicker and easier than using the sheet summary data.

    If you ultimately want it in the sheet summary data, maybe so you can add it in a dashboard as a widget, all you need to do is create the field and then have it reference a single cell in your metrics sheet (vs. putting a whole formula in it).

    Hope this helps!


  • JBolan
    JBolan ✭✭

    lawd. I thought that the : indicated entire column and literally didn't even think about the fact that the 1 might be limiting that. all better, thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!