Forms and Duplicate Entries
Hi everyone
Is it possible that when a new Form Row is created that something can trigger it to look for a duplicate row (the same number in the same field) and then remove the old row and let the new row be the current entry?
Answers
-
Hi Clayton,
Yes, I think so. You could have a formula to check for the duplicate and then move the earlier row to another sheet if there is a new submission.
Would that work?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi there. I have the same question and have already added a formula to search for duplicate entries based on the data. What would the formula look like to move the older row to another sheet?
Thank you.
-
I would be very interested in how this is implemented, as I have not figured out what condition must be met in the automation to move the record.
Also, my preference would be to move the original record, but that likely is not possible.
-
Andree is there a formula you can share? I am having the same issue., Is it possible that when a new Form Row is created that something can trigger it to look for a duplicate row (the same number in the same field) and then remove the old row and let the new row be the current entry?
-
Hi @lilygomesa
I hope you're well and safe!
How did it go? Did you manage to get something set up?
I hope that helps!
Have a fantastic weekend & Happy New Year!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
What is the formula to recognize and possibly delete (or not allow) duplicates?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Can I link a Smartsheet report in a form. My form will be for a person to confirm info from a report is correct. So I want the user to be able to view the report while filling out the form.
- I have 4 sheets used by individuals to track their work. I have a report that pulls from all 4 of those sheets to give me a total count of items they listed for the month as well as each line item (de…
- Hi All! Quick question - I am working on a form with a lot of yes or no questions, and I decided to display them as horizontal radio buttons. They are all circles except for one question, which shows …
