How To Prevent Duplicate Entries

I’m new to spreadsheet.com so I’m wondering How can a duplicate entry be prevented in a specific column?
For example, in Excel or Google sheets you can use Data Validation like below:

image

Is there anything similar?

@Luis_Omar - Great question.

You can use a column formula to highlight duplicates.

You can also make the ‘Is Uniq’ column hidden.

In the future,

  1. We plan to add ‘Highlight Duplicates in a column’ as an out of the box Conditional Formatting rule. - So that the column formula column can be avoided.
  2. We will consider input validation - there is a strong justification for it.
1 Like

Thank @Murali_Mohan , the input validation will be a great feature. Thanks

1 Like