Cell Linking

I have two sheets. One is titled Expiration Data and the other is Inspection Scope. On the expiration data sheet, I need to take the average of a column of only certain cells, and display that on the inspection scope sheet. The column is titled 'QTY Approved' and I need to filter it down to a certain part number, take that average, and show it in a specific cell on the Inspection Scope sheet.

Thanks in advance


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!