0

I have a project where Activity A is anticipated to run for a month.  And Activity B starts around the same time, maybe a little later (start date is independent of A).. however  B can NOT be closed out until A is complete.. AND B has a hard stop due date.  how do I set THAT one up?  cuz I don't

1

Hi all - I cannot figure out what's going wrong here.

 

I'm trying to count rows in another sheet ("Sheet A") where both the following are true:

  • Done = 0
  • IsChild = 0

My formula is: 

  • =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 4}, 0)

 

Now this works perfectly!

 

So in a cell right below that

3

I have a sheet that I inherited and it has all kinds of fields used for statistic reporting. I want to edit the sheet, but don't know what formulas on this or other sheets I might break if I edit it.

Is there a way to know if a cell is used in a formula somewhere else?

Thanks,

2

Hi, I am looking into utilizing a ITIL related priority matrix approach to populate a Priority.   The 

Priority levels column's cell would have values P1, P2, P3, P4, P5.   The formula needed in the Priority column would output an appropriate priority level based on specified combination of values