Summary Report



In a typical sheet of say 10 tasks i have, where applicable, resource names assigned per row. I would like to add up all the named resources on a sheet and display them in one cell in my summary report. Is this possible?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Ok. You will need to create a Multi-Select Dropdown Column (or field in the Sheet Summary). Then you will want to enter the below:

    =SUBSTITUTE(JOIN([Contact Column]:[Contact Column], CHAR(10)), ", ", CHAR(10))

    The delimiter in a multi-select contact type column is ", " (comma space), but the delimiter in a multi-select dropdown type column is CHAR(10) (line break).

    So we use the JOIN with the CHAR(10) to pull each contact cell together, replace the ", " in each cell with a line break, then drop them into a multi-select dropdown column to filter out duplicates.