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 for help with Smartsheet, integrations, general workflow advice, or anything else.
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, ColumnB@row, ColumnA:ColumnA, ColumnA@row) > 1, "Duplicate", "Original")
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I created a timesheet and a form to go along with it. When someone uses the form and flags that someone has called off, I want the flag to return zeros in the ST Hrs, OT Hrs, and DT Hrs cells. Using AI to generate the formula below, it returns a Circular Reference error when the formula is placed in the ST Hrs cell.
I have created a form that is for use with two separate groups, fields become available dependent on how respondents answer questions. I have a VLOOKUP formula set to pull in the address information from another sheet. Because this is used between two separate groups, there are two name fields. I am trying to compare both…
Not sure if this is possible. Column can vary from 2 to X cells A couple of scenarios: A column two cells with 12 and 14. Total is 26. In the resultant cell 16 is inserted. (any sum of 17 or greater the number 16 is inserted) A column has a number of cells that total 14. Seeing that the number is less than 16 the actual…
©2024. All Rights Reserved Smartsheet Inc.