Combine Project Name and Planned Start Date.

[IsaDi]

Is there a way to merge project names that share the same start day into one line?

I’ve created a project report to combine ‘Project Name’ and ‘Planned start Date’ into one column.  I would also like the report to show all projects that are starting on the same date into one line. 

Thank you!

Here is what I need:

Project Name

10/6/23 Iris Detect eComm ATF-BTF Graphics (US) 2024 Ferguson Calendar Ad

10/13/23 THD 2024 Gold Awards Patriotic Program Ad – First Responder Bowl

Here is what I get:

Project Name

10/6/2023 Iris Detect eComm ATF-BTF Graphics (US)

10/6/2023 2024 Ferguson Calendar Ad

10/13/2023 Patriotic Program Ad – First Responder Bowl

10/13/2023 THD 2024 Gold Awards

I have the text below:

column.0.displayname=Upcoming DRs

column.0.sharecol=true

column.0.sortOrder=1

column.0.textmode=true

column.0.valuefield=plannedStartDate

column.0.valueformat=atDate

column.1.sharecol=true

column.1.textmode=true

column.1.value=<br>

column.1.valueformat=HTML

column.1.width=1

column.2.sharecol=true

column.2.textmode=true

column.2.valuefield=project:name

column.2.valueformat=HTML

column.3.textmode=true

column.3.value=<br>

column.3.valueformat=HTML

column.3.width=1

[Madalyn_Destafney]

What about adding a grouping for planned start date? It won't literally combine the cells but it'll group by start date so all projects starting X date show together, Y date group together, etc.

[IsaDi]

Hi Madalyn,

Thanks for the prompt reply!  I initially tried the grouping for planned start date but was hoping to be able to combine the cells.