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?
Best Answer
-
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.
Answers
-
How exactly is [Row ID] being populated?
-
It is just an autonumber field.
-
What are the column properties?
-
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.
-
Glad it's working for you now. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!