Warning message when Duplicate entry is done through form

prathap.krishnashetty69881

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å

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

Sure will try it now.

Andrée Starå

Excellent! 

Let me know if you have questions!

prathap.krishnashetty69881

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

Andrée Starå

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

prathap.krishnashetty69881

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å

Yes, it has to be checked thru a formula!

Happy to hear you solved it!

Zafar

Hi,

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

Regards,

Zafar

sara pirie

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

Andrée Starå

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

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å

@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

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

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

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