Report grouping by date not working


I'm trying to group by end date on a project plan but the grouping is splitting out the same end date into multiple groups.



  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @mclawrence_123

    Project Sheets with Dependencies enabled have a hidden time associated with Start and End dates in order for Predecessors to identify connections. You can test this in your source sheet by adding a new text/number column and using a simple formula:

    =[End Date]@row + ""

    This hidden time means that the dates are seen differently by Smartsheet, even though the display value is the same. For your Report, you could have a hidden column that simply grabs the Date without the time that you then use for the Grouping, if that helps:

    =DATEONLY([End Date]@row) - put in a Date column