Averaging values in Column 3 for all similar values in Column 1


Hello all, I've created a formula based on the threads I've read about the "Collect" function, but it is not yet working the way I desire it. I need [% DB SDV per Site] to calculate the average of the values in [% DB SDV per Subject] for all similar [Site Number]. So, it seems my criterion is incorrect, but I do not know how to tell Smartsheet to do this.

Is this possible to do?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!