Calculating Average Days between 2 columns

Hi All!

I am making a report for a Risk Submission Sheet and I have two columns within my sheet: "Date Submitted" and "Date Closed."

I want to create a widget for a report that calculates the average days it takes to close a risk from the "Date Submitted" to the "Date Closed" for ALL submissions.

Knowing that 1) risks added are ongoing and 2) some "date closed" fields will be empty until closed, how would I write this formula?

My head is hurting from trying to figure this out, so any help is super appreciated.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!