Formula Help - Need to collect number of projects labeled "High" in another sheet

edited 07/21/22 in Formulas and Functions

Currently using the PMO template pack and the formula in the portfolio Metrics does not seem to be adding up the categories correctly. Here is the sheet I am working in:

the numbers in the High, Medium, Low columns are not accurate. I need them to pull from the main sheet the total number of projects labeled as High/Medium/low

Current formula being used: =COUNT(COLLECT({Project ID}, {Priority}, High$1))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!