HELP!!!

jeff steffen

=COUNTIFS({Belleville - 1N Front St (task) Status}, [Not Started]@row, {Belleville - 1N Front St (task) Status}, "Children"

I am trying to create a formula for my in progress tasks. My countifs keeps changing to not started and the formula is giving me an error. My total In Progress is calculating wrong bc it is including my ancestors.

Please help!

Razetto

@jeff steffen Hi, What about adding a column to indicate the level (0=parent, 1= children,...)? Use the following =COUNT(ANCESTORS(Primary column@row)). It has to refer to your primary column as that's where the indentation happens.

Assuming that the column name for the various statuses is Description, then your progress formula can be: =COUNTIFS({Other sheet Status column}, Description@row, {Other sheet Level column}, NOT(0))

Hope it helps!

jeff steffen

I clicked on the the first indent (Acquisition) or on the task below it? Also when I go to change column, I get an error so I had to drag to copy! Appreciate the help

jeff steffen

This is how I have it set up in my main sheet. The problem is it is counting the first two headers in my totals. Make sense?

Razetto

@jeff steffen Reference the top level which will be 0, the next level will be a 1, the next a 2....