Is there a way to get pop up message saying there is a duplicate entry of the line u entered through form. Something avoids duplicate entry.
Unfortunately, it's not possible at the moment to get any message in the form, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
A possible workaround could be to have automation send an update request if the value submitted is a duplicate.
Would that help/work?
Have a fantastic day!
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Sure will try it now.
Let me know if you have questions!
i tried but there is no clear option. i have submitted ER.
What do you mean that there isn't a clear option?
i mean there is no duplicate check option in the workflow. However, i have figured it out by the formula in the datasheet.
Yes, it has to be checked thru a formula!
Happy to hear you solved it!
Is there any option to restrict duplicate entries in option. Please let me know. It will be very useful.
This my problem too and im very new to smart sheet so need more help
Hi @Zafar & @sara pirie
Not sure I follow!
Can you describe your process in more detail?
How would you want to use it?
I hope that helps!
Be safe and have a fantastic week!
✅Did my post(s) help or 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!
As a follow up to this, if I have a value range (example gift certificate numbers) for selection, is there a way ot prevent the smae one being picked twice? so it would be removed from the possible selections when it has already been selected?
Thank you kindly
I hope you're well and safe!
Excuse the late response.
Crazy times and I missed coming back to you.
Have you solved it, or do you still need help?
Happy New Year & Stay safe!
Dear Andrée Starå,
@Andrée Starå Regarding this duplicate entry restriction - I created a form in Smart sheet where all the employees used to check-in their attendance, but sometimes few of them are submitting twice/thrice on a same day. Hence, I require an solution to stop the duplicate entry in Smart sheet form.
Hope this clarifies.
This feature would solve so many problems.
I am using Forms to collect inputs from people and now I have to export to excel and check for duplicates and merge data from other columns. This is a very time-consuming exercise.
Try this formula in a separate field or column of ur master sheet: it should help u to identify duplicate rows.
=IF(COUNTIFS(ColumnB:ColumnB, [email protected], ColumnA:ColumnA, [email protected]) > 1, "Duplicate", "Original")
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
©2022. All Rights Reserved Smartsheet Inc.