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

Find more posts tagged with

Formulas

Reports

functionality

Accepted answers

All comments

Sandhiya07

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

EmmaSob

https://community.smartsheet.com/discussion/comment/314024#Comment_314024

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

Sandhiya07

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.