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?

Answers

  • Lucas Rayala
    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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!