Forum Discussion

RobertOrnelas's avatar
RobertOrnelas
Iron Contributor
Jun 07, 2022

Schedule Report

Is a view/report similar to this possible in MS Project?  our plant is used to seeing an Excel spreadsheet like this, which is very efficient.  Basically, it's a Gantt chart where each cell is a task...
  • John-project's avatar
    John-project
    Jun 08, 2022
    RobertOrnelas,
    Yeah Project has a lot of subtle options that can make all the difference.
    1. Double click on the summary line to bring up the task information window. Check the "Hide Bar" option. That will hide the summary line bar but allow rolled up subtask bars to appear, as long as the Rollup field is marked ad "yes" for the summary and all subtasks.
    2. There is no "Subtask Name" field, the field is simply "Name", as shown in my screenshot.

    Does that help?
    John
Dale_HowardMVP's avatar
Dale_HowardMVP
MVP
Robert -- If I were your organization, I would continue to use Microsoft Excel for this purpose. Just my two cents' worth. Hope this helps.
RobertOrnelas's avatar
RobertOrnelas
Iron Contributor
Jun 07, 2022

Dale_HowardMVP Thanks for the input.  We've been using this spreadsheet for a while, and we have developed a series of macros to try to make it behave like scheduling software.  Each of these products needs to be drawn, produced, and installed, and now 3 separate departments are faced with maintaining 3 separate schedules.  I was kind of hoping that Project would be an upgrade since that's what it was designed to do.