Trying to list distinct values from another sheet with a certain status

I am trying to list out distinct values from a separate sheet that are not marked as canceled. I am using this formula, and I only see a blank cell, even though the source sheet is populated.

=IFERROR(INDEX(DISTINCT(COLLECT({Drug Name}, {Project Status}, @cell <> "Canceled")), [Primary Column]@row ), "")

Find more posts tagged with

Accepted answers

hdierkers

I ended up seeing another article that suggested adding a helper column to add "" to the column name because I was trying to collect distinct values that had repetitive information; then I created a collect/distinct link to that and it worked!

All comments

Adam Murphy

Hi @hdierkers,

I would try using JOIN/COLLECT since you are trying to capture multiple values. Try something like =JOIN(DISTINCT(COLLECT({Drug Name}, {Project Status}, @cell <> "Cancelled")), ",")

Would that work?

hdierkers

Marcela

Hey @hdierkers, I'm glad you figured it out! Thank you for sharing your solution!

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.