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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!