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.

Tags:

Answers

  • 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

    Cheers,
    Genevieve