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

Vikki Cooper
edited 12/09/19 in Archived 2017 Posts

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


Thank you in advance


This discussion has been closed.