Options for maintaining What-if Scenarios?
OK, it looks like we don't currently have an option to maintain multiple What-if scenarios. (Which I define as putting in some worst or best case durations in a linked project to see what the impact will be.)
Any practical workarounds for maintaining one project (with all the same predecessors) for different durations?
My ideal end state would be two lists of finish dates or gantt charts, one for best case and one for worst case, side by side. I could then play around with durations in the worst case in order to see the impact.
Thanks in advance for your ideas! I am stumped.
Comments
-
Set up your first project sheet (worst case for this example). Include a column that replicates the row number. The formula for this is
=COUNTIFS([Primary Column]$1:[Primary Column]@row, OR(NOT(ISBLANK(@cell)), ISBLANK(@cell)))
.
You would then "Save as New" to create a copy. From there you can change your dates to best case.
.
Once both sheets are built, you would create a report that would look at both sheets and pull whatever pertinent data you need. Sorting by the row number column will ensure that each task is displayed with the same task from the other sheet, so it would look something like this.
Best Case Task 1
Worst Case Task 1
Best Case Task 2
Worst Case Task 2
Best Case Task 3
Worst Case Task 3
.
Is that something like what you are looking for?
-
Thanks for your idea, Paul!
Sorry for my delayed response. My customer changed their mind and I dropped it.
Yes, your idea would work. Very clever with the row sorting! :)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives