Count if formula and task progress

Jordanbdavis6 ✭✭
edited 12/09/19 in Smartsheet Basics


I've been trying every way possible to set this up so hoping someone can assist--

I would like to create a dashboard with a pie chart that shows how many tasks with a due date for the past 30 days from a sheet are done or incomplete. This seems simple enough, but Smartsheet keeps telling me I can only use numeric values to create a chart, not data from my status column. 

So, I tried to create a new sheet that just turned this info into numbers. I was trying to use the countif formula-- essentially, I want the number of tasks that are marked done with deadlines from the past 30 days. Any idea how I can set this up? Any help would be much appreciated, thank you!