Hello! I am trying to come with a total number based on region and type of project.

For example, the project type is new product, the region is APAC and the 1yr rev is $1M. I need a metric where the formula captures the same region, the overall number of project types and the overall revenue. Does that make sense? Here is an example


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!