MTaylor’s Profile

Community member since August 2017

points
41

1

I am trying to determine a way to communicate/graphically represent project progress based on today's date in relation to the start date and projected end date of a project. So if we have a 90 day project and we are on day 50 I want to see Project Progress of 55%

I already have a data point for Task

1

here are the formulas and a look at the Spreadhseet.

The Column labeled Column has the following formula

=SUM((COUNTIF(CHILDREN(Passed10), 1) / SUM(COUNT(CHILDREN(Passed10)))))

 

The current formula in the Status column for the Exception Rules row10 is =IF(Column10 = 1, "Pass", IF(Column10 = 0, "Not