Counting values


I have over 30 sheets which I store the portfolio the belong to in a sheet summary field (a drop down). I am needing a way to count these values. I am wanting to count how many schedules have the value "ETG Project Portfolio 2020" in the Portfolio summary field.

thanks in advance for the help.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!