Formulae to calculate AVG days for Task completion meeting certain conditions
=AVG(COLLECT({Type}, "Plan Change", {Status}, "DocuSign Approved"), {Days to complete})
I am trying to calculate the Average no of days to complete the task. The {Days to complete} is a column where count of days is being populated by calculating the start and end date.
The two conditions are 1. Plan change under Type column and 2. DocuSign Approved under Status Column.
Its throwing an error - INCORRECT ARGUMENT
Please help.
Best Answer
-
Happy to help. 👍️
Answers
-
Try this one...
=AVG(COLLECT({Days to Complete}, {Type}, "Plan Change", {Status}, "DocuSign Approved"))
-
Thank you for sharing the revised formulae.
Its now giving me the error #DIVIDE BY ZERO... I assume we are closer to the result with one missing step
-
Thank for helping. The error resolved...
-
Happy to help. 👍️
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
Check out the Formula Handbook template!