Smart Sheet Summary for average time between two dates for two columns
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?
Help Article Resources
Check out the Formula Handbook template!