Pivot table showing date
Hi All,
We have a bunch of project schedules that list milestones in the primary column (IE Kickoff, First Milestone X, Construction complete, etc). So each milestone has it's own row.
I would like to make a report where the rows are each project (or sheet name) and the columns are the major milestones. The value in the column would be the end date. I was hoping to do this with a pivot, but Pivot cannot put a date as a value. Does anyone have any recommendations on how to achieve this? It seems so simple and straightforward, but impossible!
Answers
-
Hi Kate,
Pivot just supports SUM, AVG, COUNT format in the collumn value, not DATE format.
I suggest 2 ways for your use case:
1. Setup the Report with group feature that groups your projects by Milestone column as below screenshot
2. Create a new sheet where the rows are each project and the columns are the milestones. The value in the column is the end date. Using formula to pull in the end date of each milestone from your project sheets
Hope that helps.
Gia Thinh Technology - Smartsheet Solution Partner.
Email : thinh.huynh@giathinh.tech
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!