Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Modeling uncertainty: "Expected Value" for staff allocations on future potential projects?
My company is a consulting firm that must manage an uncertain project flow. We use one Smartsheet per project, creating a new project smartsheet whenever we submit a project proposal. However, there is always uncertainty as to whether we will actually get any particular project. We definitely don't have a 100% success rate, so we have a number of proposals for the same time period of work out at any given point. This means that we often have staff members appear as "over-allocated" in a future quarter.
What I would like is some sort of "expected value" function that would allow me to flag the allocations from different project sheets based on the percentage likelihood that the project comes to fruition. (E.g., If I think a project has 25% likelihood of going through, the 100% allocation of key staff during that project period would appear as 25% when I look at the resource view. This would give us a more realistic picture of future staff allocations and needs.
Has anyone had success with this or another approach to build uncertainty into their project planning with Smartsheet?
Thanks in advance!