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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!