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
Answers
-
Try this:
On the Inspection Scope Sheet, create this formula:
AVERAGEIF( {Expiration Data Part Num}, "Part-101", {QTY Approved})
You will need to create two Cross Sheet References to support this formula: Expiration Data Part Num, and QTY Approved.
Here is a help article showing how to create the references if this is your first time doing so: Create cross sheet references to work with data in another sheet | Smartsheet Learning Center
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!