Combine Project Name and Planned Start Date. | Community
Skip to main content
Level 2
October 5, 2023
Question

Combine Project Name and Planned Start Date.

  • October 5, 2023
  • 1 reply
  • 729 views

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Madalyn_Destafney
Community Advisor
Community Advisor
October 5, 2023

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.

If this helped you, please mark correct to help others : )
IsaDiAuthor
Level 2
October 6, 2023

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.