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

Options

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

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    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
    Andy Lorance ✭✭✭✭
    Options

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!