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?
Help Article Resources
Check out the Formula Handbook template!