Formula for AVG when only specific rows should be calculated


Working on a formula that should average number of days worked but also meets two other specific criteria and does not count any rows that are blank as 0. Below is my formula but not confident is calculating the way I need it to. Thoughts?

=AVG(COLLECT({#Worked}, {Due Date}, >DATE(2020, 12, 31), {Status}, =[Formula Descriptor]@row))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!