Column data shown in a row for a report
Good morning,
I have multiple proejct schedules that I need to filter to a summary report. But I need to take information that are in columns and show the information in rows for this summary. Is there is way I can do this without adding another sheet?
Answers
-
Hi @Cmdeluca6
There's not an easy way to do that and I assume you aren't using Control Center. One way you could do it though would be to add the fields as sheet summary fields off the right in the popout menu. Then cell link the schedule values into those fields. Then run a sheet summary report containing all the schedules.
This would manual (sheet by sheet) but then when you do save as new on your template or however you are kicking off new schedules, the links would be there going forward and could be auto-added to your report if you have the report aiming at a workspace where all your schedules are held.
Probably not the answer you were looking for but that would provide a rollup summary.
I hope that helps.
Matt
-
Thanks Matt.
So I to pull the task name (row) and then task category (milestone)and the start and end dates from the the columns based upon that row.
So I need to add each of those in the sheet summary?
And then what formula would provide me the date that relates to the task name and milestone category?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!