Forms and Duplicate Entries
![SIS](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives