Revise current formula to add IF Statement
Hello again! First, thanks for looking, and thanks even more for potentially helping, it is greatly appreciated. Okay, first, I have a working formula (wooohooo)! Okay, I now need an additional IF Statement added to my current formula, and this is where it gets tricky. The first screenshot is where my formula will go. The second screenshot is my source file. In the "Release Driver Column, the first "child" is empty when it is not my dept (Process Transformation), there is a blank in the first "child" for the other projects. I need the formula revised to where if Release Driver = Process Transformation, than the formula calculates as is. However, if that cell is blank, than that stage (not a 0) is excluded from calculating the running average. For those instances Plan Develop Running Average will show as a blank cell, and the Running Average will begin at the 2nd stage, because the release driver is not blank in that column. Thanks again!
Sheet: Date Metrics-Single Line
Column: Running Average (there are 4 stages each with this column)
Formula: =IFERROR(AVG(COLLECT([Plan / Develop - Duration]:[Plan / Develop - Duration], [Plan / Develop - End Date]:[Plan / Develop - End Date], @cell <= [Plan / Develop - End Date]@row)), "")
Project Analyst | Core Quality Services (QMS Transformation)
Help Article Resources
Check out the Formula Handbook template!