Forms and Duplicate Entries

SIS

Hi all,

I'm trying to avoid duplicate entries that can be transacted through the form I created. I have several columns but a batch number is a unique identifier for the entire row. Is it possible to delete the duplicate row based on the unique batch # or move it to a different sheet? or trigger a flag on that duplicate entry?

Thanks in advance.

=)

Christina09

Hi @SIS

Yes, you can achieve that by adding a helper checkbox or flag column.

=IF(COUNTIF([batch number]:[batch number], [batch number]@row) > 1, 1)

IF the column with batch number has more than one of the same number, it will flag/check the box. You can then add automation that triggers if the box is checked, then move to another sheet or send you an alert.

Christina09

Hi @SIS

Yes, you can achieve that by adding a helper checkbox or flag column.

=IF(COUNTIF([batch number]:[batch number], [batch number]@row) > 1, 1)

IF the column with batch number has more than one of the same number, it will flag/check the box. You can then add automation that triggers if the box is checked, then move to another sheet or send you an alert.

SIS

Thanks so much =)