Return all Values

Hi,

I used a similar formula to return values based on a "filter" and I want to return all distinct values where "Risk Resilience Level" equals "Elevated Risk" or "High Risk".

=INDEX(DISTINCT(COLLECT({Supplier Name}, {Risk Level}, "Elevated Risk")), [Row ID]@row)

This now returns a "#Invalid Data Type".

{Supplier Name} is a text field

{Risk Level} is a text field (some are blank).

What can I do to fix this?

Find more posts tagged with

Accepted answers

Pestomania

I am not sure why, but all of a sudden I opened it and it was returning valid responses.

Here is what I currently have that started working all of a sudden:

=INDEX(DISTINCT(COLLECT({Supplier Name}, {Risk Level}, "Elevated Risk")), [Row ID]@row)

I don't know if I changed something accidentally or what, but it's functioning now.

All comments

Paul Newcome

How exactly is [Row ID] being populated?

Pestomania

It is just an autonumber field.

Paul Newcome

What are the column properties?

Pestomania

I am not sure why, but all of a sudden I opened it and it was returning valid responses.

Here is what I currently have that started working all of a sudden:

=INDEX(DISTINCT(COLLECT({Supplier Name}, {Risk Level}, "Elevated Risk")), [Row ID]@row)

I don't know if I changed something accidentally or what, but it's functioning now.

Paul Newcome

Glad it's working for you now. 👍️

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.