Tasks on Track and Off Track Count

Vikki Cooper

Good Afternoon All,

The Vice President has decided that for each project plan he wants to know the below information

A count of the number of tasks that should be in progress (using start date)

A count of the number of tasks that should have started and havn't (using % complete and Start date)

A count of the number of tasks that should have finished and havn't (using % complete and end date)

How do i work this out? Here is a project plan with how all of my plans are laid out

https://app.smartsheet.com/b/publish?EQBCT=7d764c297d5e4583a038caf40498503f

Thank you in advance

J. Craig Williams

Check out COUNTIF and COUNTIFS

https://help.smartsheet.com/function/countif

https://help.smartsheet.com/function/countifs

Craig

Vikki Cooper

Hi Craig

thanks, i read that already and it didnt help me. I am not very good at formulas in the first place so i think that is why i am having issues

J. Craig Williams

Hi Vikki,

Is there anyone in your org that can help?

One of the services we offer at Smarter Business Processes is near on-demand formula help. I have a customer that calls me every month or so and needs about 15 minutes of my time to do one specific formula he is trying to build. We set up the call, we share screens, I fumble around like I sometimes do and get the formula working and he goes away happy.

You might need a bit more time, but probably not much.

Alternatively, someone will likely post some or all of the solution when they have time to think about it and write it down. (I probably don't this week or next)

Craig