Counting the number of sheets in a folder

I'm trying to add a dashboard widget that illustrates via bar chart the number of projects in two different portfolios.

I can create a report that lists all the projects in each portfolio folder, but as we know we can't summarize the report so it can feed a widget.

Probably a simple solution, but any help would be appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!