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
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
Comments
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives