Concatenating cells from a different sheet matching certain constrain

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

Find more posts tagged with

Accepted answers

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

All comments

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)

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.