stephanie78
New Member
- Joined
- Jan 13, 2014
- Messages
- 1
Hi
I have created a Gantt style chart which plots out the timeline of 3 key global project phases (initiation/execution and closure) plus 5 country phases (phase 1 thru to phase 5)
The start date of country phase 1 dictates the start dates for each of the 3 project phases and this works fine.
The end date of country phase 5 dictates the closure date - this works fine if the project has 5 phases, however it could be the case that a global project (smaller in scope) only has 3 phases, for example. In which case I need to pull across the closure date from a different cell.
So I think I am looking for a formula that as a default will copy the content from cell d26, if this cell is empty then will copy content from cell d25 if this is empty copy data from cell d24 etc.
Secondly, I am struggling with the x axis of my chart for the timeline as the timeline doesnt automatically populate accurately each time a new start date is selected. I have needed to format this each time using the numeric equivalent of the start and end date. Is there anything we can do here to automate it?
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL></COLGROUP>
I have created a Gantt style chart which plots out the timeline of 3 key global project phases (initiation/execution and closure) plus 5 country phases (phase 1 thru to phase 5)
The start date of country phase 1 dictates the start dates for each of the 3 project phases and this works fine.
The end date of country phase 5 dictates the closure date - this works fine if the project has 5 phases, however it could be the case that a global project (smaller in scope) only has 3 phases, for example. In which case I need to pull across the closure date from a different cell.
So I think I am looking for a formula that as a default will copy the content from cell d26, if this cell is empty then will copy content from cell d25 if this is empty copy data from cell d24 etc.
Secondly, I am struggling with the x axis of my chart for the timeline as the timeline doesnt automatically populate accurately each time a new start date is selected. I have needed to format this each time using the numeric equivalent of the start and end date. Is there anything we can do here to automate it?
Start Date </SPAN> | Numeric equiv</SPAN> | End Date</SPAN> | Numeric equiv</SPAN> | Duration</SPAN> | |
PROJECT INITIATION AND PLANNING</SPAN> | 8/6/14</SPAN> | 41798</SPAN> | 31/12/14</SPAN> | 42062</SPAN> | 206</SPAN> |
PROJECT EXECUTION</SPAN> | 3/7/14</SPAN> | 41823</SPAN> | 14/2/15</SPAN> | 42049</SPAN> | 226</SPAN> |
Phase 1</SPAN> | 8/6/14</SPAN> | 41798</SPAN> | 31/10/14</SPAN> | 41943</SPAN> | 145</SPAN> |
Phase 2 </SPAN> | 8/8/14</SPAN> | 41859</SPAN> | 31/12/14</SPAN> | 42004</SPAN> | 145</SPAN> |
Phase 3</SPAN> | 8/9/14</SPAN> | 41890</SPAN> | 31/1/15</SPAN> | 42035</SPAN> | 145</SPAN> |
Phase 4</SPAN> | 9/10/14</SPAN> | 41921</SPAN> | 3/3/15</SPAN> | 42066</SPAN> | 145</SPAN> |
Phase 5</SPAN> | 6/11/14</SPAN> | 41949</SPAN> | 31/3/15</SPAN> | 42094</SPAN> | 145</SPAN> |
PROJECT CLOSURE</SPAN> | 8/10/14</SPAN> | 41920</SPAN> | 31/3/15</SPAN> | 42094</SPAN> | 174</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL></COLGROUP>