Forms and Duplicate Entries
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.
=)
Best Answer
-
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.
Answers
-
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.
-
Thanks so much =)
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