Merging one column across many rows - how is this possible in Workfront? | Community
Skip to main content
OliviaMi
Level 4
Feb 18, 2022 4:44 PM UTC
Question

Merging one column across many rows - how is this possible in Workfront?

I have a report where I am pulling in several tasks from a project, and want to show a custom field at the project level with scope detail for those tasks. However, that custom field at the project level shows up repeatedly with each task I am pulling in. Is there a way to merge that column into one, so I have multipe task rows but the custom field only shows up once? This is possible in Excel, so hoping it is possible in a report in WF.

Thank you,

Olivia

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

4 replies

skyehansen
skyehansen
Level 4
Feb 18, 2022 6:20 PM UTC

sounds like you are in a task report? If so, my advice would be to leave the column out completely and just group it by that custom field.

Translate
    OliviaMiAuthor
    Level 4
    Feb 24, 2022 1:08 AM UTC

    I have it grouped by project, and this field is a data field that is applicable to each task I want shown as a column... so that it looks like the screenshot with this comment. Is there a way to do that?

    Thanks for the assistance!

    Translate
    skyehansen
    skyehansen
    Level 4
    Feb 24, 2022 1:29 AM UTC

    the closest way to do that is to group it first by Project and then by the FG Numbers field and just remove the column completely.

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...