Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Tasks on Track and Off Track Count
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
Comments
-
Check out COUNTIF and COUNTIFS
https://help.smartsheet.com/function/countif
https://help.smartsheet.com/function/countifs
Craig
-
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
-
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
