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 nonhyperlinked 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

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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!