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,
Emma
Answers

Hi @EmmaSob ,
Hope you are Good and Safe!
As per my understanding you are asking for the number of hours between dates so in that case, you can find out no of days i:e [Start date end date] and then multiply by 24.
If I'm wrong means Could you please explain with Sample data.
Thanks,
Sandhiya P

Hi @Sandhiya07
Thank you for your reply. No, this isn't quite what I'm after. I'm not wanting to create additional columns in the sheet to make the calculation, hence the desire to do the formula in a smart sheet summary field. I also don't need to work out hours, just days.
Many thanks,
Emma

Hi @EmmaSob
As per my Understanding, atleast we need to create atleast one column to calculate No of Days and then we will show Average for each Project in Sheet Summary. Like below,
Please suggest if this solution is helpful for you.
Thanks,
Sandhiya P
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 352 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!