Need help applying AvgIf and/or AvgCollect
Answers
-
Current formula I am trying: =AVG(COLLECT(TAT:TAT, [Run Type]:[Run Type], OR(@cell = "A", @cell = "B")))
It isn't pulling the average correctly.
-
Your formula is going to grab all rows where the Run Type column is either "A" or "B". Based on the screenshot, that means it is going to pull in all 3 numbers and average them (23).
Is it not supposed to pull in both letters?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 383 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!