Summary Field that Averages Field Entries that are Less than Zero

I have a calculated field for the time over or under a deadline date. I want to create a summary field that summarizes the number of days overdue for projects completed after their deadlines.

Right now I'm trying =averageif([field name]:[field name],<0,[field name]:[field name])

I get an "Invalid Operation" error when I do this. Can someone give me some advice on a better approach?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!