AVG(COLLECT) Formula Questions

I've looked at a lot of posts already about using this formula and have tried all the suggestions but I'm still getting an UNPARSEABLE error. Hopefully, I'm just doing something simple wrong, like having a common in the wrong spot. But I want to use two criteria... if the MRD column is checked, and the Task Name equals "Requirement Complete", then average the % Complete.

This is my current formula... =AVG(COLLECT([MRD]1:[MRD]109=1, [Task Name]1:[Task Name]109="Solution Complete", [% Complete]1:[% Complete]109))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!