Is this a bug and if so, how do I mitigate it?

I have a formula to autopopulate a drop-down list field to show one or more items, grouping together a number of related rows in another table.

=JOIN(INDEX(DISTINCT(COLLECT({EcoTech Activities Managers}, {Activities PIDs}, =ID@row)), 0), CHAR(10))

Basically collect the names of managers from another table where the key matches the key of this specific row. This has worked fine in the past, and typically looks like this:

But today, it's started doing this, returning data from a different column and row. "P2" is the value in the first row of this table, it's not even a value in the lookup table. That's a bug right!?

If I refresh the table, the correct values come back, then after a minute of two, they recalculate to this incorrect value. What's going on?

BTW - this isn't the only formula on this field that is doing this. For some reason the formulas keep replacing results with data from the first row in the current table.

Any ideas what might have caused this error, and is there any way I can mitigate it, or fix it?

Find more posts tagged with

Formulas

collect

References

INDEX

Accepted answers

All comments

Paul Newcome

What happens if you get rid of the INDEX function?

=JOIN(DISTINCT(COLLECT({EcoTech Activities Managers}, {Activities PIDs}, =ID@row)), CHAR(10))

eseymour

Thanks @Paul Newcome - I have tried that. I am actually not quite sure why it had the 'index' in there anyway! That is working as expected, but I'll keep monitoring it to see if the weird bug pops up again, and will report back.

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.