Return all Values

Pestomania

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?

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

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. 👍️