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




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!