AVGW Formula with Conditions

Kaleb

Smartsheet Community:

Does anyone know how I can get Average Weigh Only if Criteria is Met?

For Example I want the AVGW if The Status is Open or Potential.

Current Formula without Criteria:

=AVGW([Risk Score]:[Risk Score], [Schedule Impact]:[Schedule Impact])

Thanks

Kaleb

https://community.smartsheet.com/discussion/99639/avgw-formula-with-conditions

Smartsheet Community:

I Created a Helper Column to Only Populate the Risk Score when The Status is Open or in Potential Status.

Here is The Formula:

=AVGW([Risk Score Helper]:[Risk Score Helper], [Schedule Impact]:[Schedule Impact])