Smart Sheet Summary for average time between two dates for two columns

Hi all,

I am having some issues working this one out and am hoping someone might be able to help!

I have two columns in my sheet that I am interested in, "Predicted UAT Start Date" and "Actual UAT Start Date". I then have many rows for each of our different projects. What I would like to know is the average amount of time between the two dates for all of our projects (ie. the many rows). I would ideally like to do the formula in a Smart Sheet Summary field and without creating any additional columns in my original sheet.

Is there a way to do this?

Many thanks,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!