Merging one column across many rows - how is this possible in Workfront? | Community
Skip to main content
O
OliviaMi
Level 4
February 18, 2022
Question

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

  • February 18, 2022
  • 1 reply
  • 856 views

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.

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
February 18, 2022

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.

    O
    OliviaMiAuthor
    Level 4
    February 24, 2022

    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!

    skyehansen
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe Champion
    February 24, 2022

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...