How to do weekly distribution of a value in between two dates

Hello,

I have a scope value with start and end dates. I am looking how to distribute the scope (weekly) in between these two dates. I want to do a bell curve distribution. Or at least linear distribution.

Also, If I change the finish date, the distribution should adjust accordingly.

Is this possible in Smartsheet ? If yes, please help.

Thanks in advance,

Regards,

Satishwar Raju

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @Satishwar Raju Somalraju

The easiest way to do this would be to set up a helper-column which shows the breakdown per-week. You could call this column "Weekly Scope". Then the formula in the column would simply be as follows:

=Scope@row / Duration@row

This would give you a weekly distribution, although not a bell-curve one.

Personally, I would then create a Report (see here) to show all the rows that have a Start Date in the Past and an End Date in the Future (so any rows that are currently active) to identify the scope for that current week. You could even create charts from this Report in a Dashboard, if that would be helpful.

Let me know if this works for you!

Genevieve

Andy Lorance

Voting this one up ... I'm also looking for a way to create a bell curve reflecting hours distribution between two dates. I'm currently using flat distribution and rolling all of the items into a graph from there, but it's not as accurate as I would like it to be.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.