Smartsheet does not appear to contain the averageifs formula. Is there an alternative that will perform a similar function. I would like to collect an average score of a sales person based on a text field which contains the region serviced. As there may be overlap in some instances I can not use the averageif option
For example: If one Sales person covers both North and East I would like to avg the scores of both of those regions for that individual.
Help Article Resources
Check out the Formula Handbook template!