Desperate for help-dashboarding

Jen Niemann
edited 12/09/19 in Smartsheet Basics

Ok about to rip my hair out on this. I am needing to create a portfolio view dashboard and when dashboards were widget driven I COULD DO THIS EASILY. I just want numbers for the following on the dashboard-

# of Executing projects by PM (Name)

# of projects >50% 

# of projects <50%

# in Yellow, Red, Green

# Paused (yes this is a status here)

# Not started

# Described as budget level

# in discovery


I tried COUNTIF but that is a hot mess that is very long-and it does NOT WORK. Help!!