Formulae to calculate AVG days for Task completion meeting certain conditions

Options

=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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!