Formula for AVG when only specific rows should be calculated
Hello,
Working on a formula that should average number of days worked but also meets two other specific criteria and does not count any rows that are blank as 0. Below is my formula but not confident is calculating the way I need it to. Thoughts?
=AVG(COLLECT({#Worked}, {Due Date}, >DATE(2020, 12, 31), {Status}, =[Formula Descriptor]@row))
Best Answer
-
That should be working. If you wanted to specify to exclude blanks just to be sure, it would look something like this...
=AVG(COLLECT({#Worked}, {#Worked}, @cell <> "", {Due Date}, >DATE(2020, 12, 31), {Status}, =[Formula Descriptor]@row))
Answers
-
That should be working. If you wanted to specify to exclude blanks just to be sure, it would look something like this...
=AVG(COLLECT({#Worked}, {#Worked}, @cell <> "", {Due Date}, >DATE(2020, 12, 31), {Status}, =[Formula Descriptor]@row))
-
Thanks as always!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!