Pivot table showing date

Kate Desrochers
edited 08/10/23 in Formulas and Functions

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!


  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭

    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 Co., LTD - Smartsheet Solution Partner.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!