Formula returning unique values not working

Hi, I am using the following formula to return unique values in a spreadsheet. It works for other columns but not a specific column.

=IFERROR(INDEX(DISTINCT({WDRS Core Build Log Range 3}), IDX@row), "")

IDX is a helper column and this formula works for other columns. This specific column contains release numbers in the following formats XX.XX or XX.XX.X. Is that causing errors in the formula? Is there a way around this?

Thank You

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Are you able to provide screenshots (sample data is fine) for context?

DLove

I figured out it was the decimal point causing the issue. I went back in and changed all names from 6.2 to 6-2. This solved the problem.

Andrée Starå

Hi @DLove

I hope you're well and safe!

Excellent! Glad you got it working!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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.