Is there a formula that finds the avg of a column after omitting cells without numbers?
Answers
-
Hello Kaitlyn, are the cells without numbers 'blank' or 'text only'
-
text only
-
@Lachlan Stead would blank cells be an easier fix or does a formula exist for text?
-
By default Smartsheet should ignore cells with text when running an average, but have you found it is messing with the calculation?
One option would be to to an 'average if' formula and add the condition of between '0' and 'X' (what ever number is higher than possible in your data set) and this will ensure only numbers are considered.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 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!