Contact Collect/Join to Contacts will not filter (Current user)

I have contacts in a Collect/ Join in an [Assignee All Row] Field At its core:

JOIN(COLLECT([RowRange1]@row:[RowRange2]@row, NOT(ISBLANK(@cell))), ", ")

As far as I can tell ", " Comma-space is the delimiter for multiple e-mails in a multi-select column.

FAILS:

Filters on the sheets won't recognize (CURRENT USER) in the [Assignee All Row].
Dynamic forms filter by [Assignee All Row]
Report filter [Assignee All Row] where multiple users are specified.
*Can* filter with contains "Some name" and that works

No "OR" available for filters I.e. Assignee1 OR assignee2 - so that's a bust.

There is an old post form 2022 on this - has SmartSheets still not fixed the issues with Contacts? Support has been very unhelpful - like talking to a BOT and always focusing on other issues and topics - Like they just 'cannot' see it.

https://community.smartsheet.com/discussion/97466/combine-contacts-from-multiple-columns-into-a-single-cell?_gl=1*1snmrhd*_ga*MTkyODM4MDA2Ny4xNjk5OTIyOTk4*_ga_ZYH7XNXMZK*MTcxMDk1OTg4NS4xNDEuMS4xNzEwOTYwNDIwLjYwLjAuMA..

2024-03-20(chrome) t124156 Dynamic_View_-_Google_Chrome.gif

2024-03-20(chrome) t123408 _DB-Ticket-Input_-_Smartsheet.com_-_Google_Chrome.gif

Find more posts tagged with

Contacts

Dynamic View

Filters

Join

collect

Accepted answers

All comments

Paul Newcome

There is currently no way to use a formula to join multiple usable contacts into a single cell. You can however create a filter for [Column A] = "Current User" OR [Column B] = "Current User".

RAllen

Thanks @paul new - Fresh eyes - that might work for the sheet - but what about the Dynamic View? Does the filtered sheet apply to the DV?

Paul Newcome

You can set the filter in the sheet as a shared filter and then set it as the default view within Dynamic View where users will not be able to turn it off or adjust it. They will be able to apply their own filters on the data presented, but they will only be presented with "Current User" data as long as they are signed in.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.