Summary Formula

Hi @lukasrobbo97

Would you be able to post a screen capture of your sheet set-up with column names showing, identifying what columns you're looking at for these percents?

It sounds like you want to see how many of the Rows have passed the Start Date based on Today's Date, and how many of the rows we have now passed based on Today's Date, compared to the total number of rows there are in the sheet. Is that correct?

If this is what you're looking to do, you can use COUNTIFS to count how many rows have a Start Date that is either In the Past or TODAY

=COUNTIFS(Start:Start, >=TODAY())

If you want to filter that down to only the child rows, you can use the helper column as another criteria:

=COUNTIFS(Start:Start, >=TODAY(), [Parent Column]:[Parent Column], "Child Row")

You'd want to replace [Parent Column] with the name of your column, and "Child Row" with whatever it is that you're using to indicate an indented row.

Then once you have this count, you can take a Count of all the rows, regardless of date:

=COUNTIFS([Parent Column]:[Parent Column], "Child Row")

With these two calculations you can find the %:

Number of rows that started before Today / Number of total task rows

=COUNTIFS(Start:Start, >=TODAY(), [Parent Column]:[Parent Column], "Child Row") / COUNTIFS([Parent Column]:[Parent Column], "Child Row")

You can do the same thing with the Finish Date column, looking to see if the date is in the Past instead of in the future:

=COUNTIFS(Finish:Finish, <=TODAY(), [Parent Column]:[Parent Column], "Child Row") / COUNTIFS([Parent Column]:[Parent Column], "Child Row")

See: TODAY Function and COUNTIFS Function

Cheers,

Genevieve