Help with INDEX/DISTINCT Not Working!!

I have the following formula:

=IFERROR(IF(Auto@row = 0, "COMPANY NAME", INDEX(DISTINCT({Company Name}), [Row ID]@row )), "")

Problem is - it has stopped working. It pulled out the first 115 vendors out of 425 items, and then stopped. Is there a maximum number of distinct items it will pull into a list? I do not see any reason that should be the case, but I, for the life of me, cannot figure this one out.

Help?

Find more posts tagged with

Formulas

Accepted answers

Michelle Choate 2

Ah goodness…. I figured it out. I forgot that the formula would not add new entries into the column, that I had to have the rows already available and numbered in order for it to plop in the individual names.

All comments

Michelle Choate 2

@Paul Newcome - Please help!!

Michelle Choate 2

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.