Warning message when Duplicate entry is done through form

prathap.krishnashetty69881 · 08/14/19

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.

Andrée Starå · 08/14/19

Hi Prathap,

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!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

prathap.krishnashetty69881 · 08/15/19

Sure will try it now.

Andrée Starå · 08/15/19

Excellent!

Let me know if you have questions!

prathap.krishnashetty69881 · 08/17/19

i tried but there is no clear option. i have submitted ER.

Andrée Starå · 08/17/19

What do you mean that there isn't a clear option?

prathap.krishnashetty69881 · 08/21/19

i mean there is no duplicate check option in the workflow. However, i have figured it out by the formula in the datasheet.

Andrée Starå · 08/21/19

Yes, it has to be checked thru a formula!

Happy to hear you solved it!

Zafar · 08/04/20

Hi,

Is there any option to restrict duplicate entries in option. Please let me know. It will be very useful.

Regards,

Zafar

sara pirie · 08/06/20

This my problem too and im very new to smart sheet so need more help

Andrée Starå · 08/11/20

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!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅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!

Al Dawson · 10/07/20

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

AL

Andrée Starå · 01/04/21

@Al Dawson

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!

Productivity Tracker · 04/13/21

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.

Thanks,

Zafar

Prashant Thankappan · 06/09/21

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.

prathap.krishnashetty69881 · 06/12/21

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")

Explore. Ask. Answer.

Warning message when Duplicate entry is done through form

Answers