Duplicate Values For Columns with Hyperlinked Values

I've found a formula to indicate whether there's a duplicate value in a column, which is great. However, it appears Smartsheet does not recognize any cells that are hyperlinked so the formula treats this as a negative, even if the values are identical.

I've noticed other issues related to hyperlinked cell values like when sorting in a Report view, it puts non-hyperlinked rows above hyperlinked ones, plus it will not group them together.

Is this a feature or a bug? Are there any workarounds for the duplicate hyperlinked value issue?

Find more posts tagged with

Formulas

hyperlink

Accepted answers

All comments

Lucas Rayala

Hi @RyanFMurphy, regarding the duplicate value: below I've created four identical cells, two with hyperlinks, two without. You can use the following formula to count the duplicates:

=COUNTIF([Column2]:[Column2], [Column2]@row)

In the below example, I used the same formula in the first and second row of Column3 -- both provide the same answer, meaning they both search for and find four (4) instances of the text "This is a hyperlink", regardless of whether the cell actually contains a hyperlink.

Can you share the formula you are using and an example where the the formula did not detect duplicates?

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.