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.

Report - Imported sheets are shown but new Project Sheet does not

Ron M
Ron M ✭✭
edited 12/09/19 in Archived 2017 Posts

Hello,

The majority of the time we import an MS Project schedule and have had no problems with pulling those into a report.  However, if we create a new blank Project Sheet and enter the tasks through the web interface, those sheets do no get pulled into the report.

The columns for the Start & End dates are different between the two, but even if we manually change them to be the same either through inserting them or renaming them, the "native" Project Sheet does not get pulled in.

I tried modifying the report to test against the two different columns for start and end dates, but that also did not correct the problem.  

Any suggestion as to what else to try?

 

Regards,

Ron

 

 

Tags:

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Check:

    1. Columns need to be same TYPE and well as name.

    2. Other criterion - if there is a criteria for a column that does not exist in the sheet (even if the criteria is blank or 0 or some other value that seems to match, it might not)

    Craig

  • Ron M
    Ron M ✭✭

    Hello,

    After reviewing the criteria, the % Complete column was blank on some tasks instead of being set to 0 by default.  Changing this solved the issue.

    Thank you!

     

    Ron

     

This discussion has been closed.