Concatenating cells from a different sheet matching certain constrain

Alberto CONCEJAL LÓPEZ

Hi,

I'd need to add a list of the latest projects to a dashboard,

the list could be some columns like CUSTOMER + COUNTRY + CITY and the constrain its in another cell called WEEK, at the same time adding (=WEEKNUMBER([Received Date]@row))

what i expect is something like:

customer1 france paris 15

customer2 spain madrid 15

customer3 belgium antwerpen 15

Thanks!

Alberto

Heather Duff

Hi @AlbertoCL ,

Have you considered adding a helper column to your source sheet, then creating a report? Your helper column (which could be hidden) could have a column formula that creates that concatenated string:

=Customer@row + " " + Country@row + " " + City@row + " " + WEEKNUMBER(Date@row)

Then you could create a report that only contains the helper column, and share that report on the dash. If you want to filter the report to show only certain customers, or only a specific date range, it would be easy to add the filter to the report.

Hope this helps!

Best,

Heather

Heather Duff

Hi @AlbertoCL ,

Have you considered adding a helper column to your source sheet, then creating a report? Your helper column (which could be hidden) could have a column formula that creates that concatenated string:

=Customer@row + " " + Country@row + " " + City@row + " " + WEEKNUMBER(Date@row)

Then you could create a report that only contains the helper column, and share that report on the dash. If you want to filter the report to show only certain customers, or only a specific date range, it would be easy to add the filter to the report.

Hope this helps!

Best,

Heather

Alberto CONCEJAL LÓPEZ

iT HELPS INDEED!

not finished yet, thou:-)

i have created and hide the helper column but i cant add it to the report the way i want (i only need those matching my latest week) how can i filter it?

Thanks!

Alberto

Alberto CONCEJAL LÓPEZ

I finally created a report and then added it to the dashboard but for filtering (the only thing left:-)) i cant find filtering by LATEST or highest number as i dont want to need to update the filter number (i.e filter by week 15) and i'd rather not populate it myself,

Thanks!

Alberto