AVG COLLECT for End Date with current YEAR
I am getting an #UNPARSEABLE error with this Sheet Summary formula:
=AVG(COLLECT(Duration:Duration,Level, 0, Status:Status, "Complete",Status:Status, "In Progress", [End Date]:[End Date], IFERROR(YEAR(@cell),0)=YEAR(TODAY())))
I would like to return the average Duration where: row Level is 0, Status is Complete or In Progress, and End Date contains 2023.
Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!