Count if formula and task progress

Jordanbdavis6

Hi, 

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!

Paul Newcome

Try using a COUNTIFS function something along the lines of...

 

=COUNTIFS(Status:Status, "Incomplete", [Due Date]:[Due Date], > TODAY(-30), [Due Date]:[Due Date], <=TODAY())

 

Of course you'll need to change the column names, but this should do the trick for you.