=average of more than one criteria
=AVG(COLLECT([Closing Date]:[Closing Date], "", [Days ago]:[Days ago], (Category:Category, "Purchasing")))
I'm trying to average the closing date of a row but i also want to itemize the closing dates by category. no sure what I'm doing wrong, new user
Help Article Resources
Check out the Formula Handbook template!