Report grouping by date not working

mclawrence_123

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.

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