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.
Need help setting up a simple report
Trying to figure out how to set up a report that would simply list my projects and percentage of completion of each project. i do not need to see primary tasks, just one line per project with the smart sheet name, date started and due, and percentage of completion.
I have tried to set it up cannot find a way around Primary tasks popping up in the report. Any ideas?
Thank you
Comments
-
I think that you are required to have the primary column. you can rename or simply hide the coulmn. Right click the coulmn header and select "hide column". Save teh report and it will be hidden until you unhide it.
-
I am assumming that you are using a hierarchy (Summary bar with sub tasks).
Have a valie in the Project Summary row somewhere that says its the Project Summary i.e. in the Primary field is usually best then use that to filter to show only the ros that have that value in it.
-
I'm doing exactly what James suggested. We have 4 sheets with projects for each department. The sheets contain a project summary row and in many cases subtasks below the summary row.
We enter a project # for the Project summary row which identifies the main row.
You could use this field to pull the project summary row into your report.
in our sheets, we track all sizes on projects so we only want the major ones on the weekly report to the CIO. To only pull the big projects, we added a Check box column called "Report to CIO". If checked, the report pulls in the project summary row.
Hope this helps.
Tim
-
Thank you all. Tim, I got what you are saying. I inserted a "#" into the top row and used that as one of the "What" filters in the report and so I was able to get exactly what I wanted. Thank you.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives