Conditional Formatting for Duplicates

James Trusheim

Adding the ability to do conditional formatting by column, similar to how I would flag a column for duplicates in Microsoft Excel.

SteCoxy

This would be really useful to have immediate functionality for this. There is a workaround where you use a helper column that is a checkbox that gets ticked using a formula that looks for duplicates. You can then apply conditional formatting on the rows that have the checkbox ticked.

https://community.smartsheet.com/discussion/73270/formula-for-duplicate-entries/p1

Realise it's not ideal, but it's the best that can be done at the minute.

lindslink

Is the functionality for real-time detection of duplicates on a roadmap, like how Excel auto-completes a cell if duplicate?