Can I count the status in a projectplan, to directly display on the dashboard?


Hi all,

I would like to include in a dashboard, the count of each 'status' in a projectplan and the percentage of that status appearing in the plan.

I can do that with a countif(), but THEN I need to make a report, to be able to display it in a dashboard.

Is there a way to get it directly in the dashboard, or with a minimum number of sheets, eg a summary directly in a report? I need to do this for 22 projects in the organization, and every added sheet needs maintenance and adds complexity.

Thanks for sharing your thoughts!

Kind regards



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!