How do I prevent multiple responses (same response) being received?

Joyce Charles

I send out a survey form to be completed. When I receive the response back there is sometimes a duplicate row/s created on Smartsheet. I have automation to receive the response via e-mail and it appears that the exact response is being received multiple times. How can I prevent this so that only one response is received per completion of a form per person completing it if I do not know who the contact/person completing it

Complaint from Survey.docx

is.

Gia Thinh

Hi Joyce,

I have an idea:

1- Create a RowID column with the Auto-number property

2- Create Duplicated column with the following formula. This formula checks if there are any rows with the same content as their previous row, marking them as Duplicated..
=IFERROR(IF(AND(COUNTIF(Content:Content, Content@row) > 1, RowID@row > MIN(COLLECT(RowID:RowID, Content:Content, Content@row))), 1), 0)



3- Create an automation worflow to remove any rows marked as Duplicated

Hope it works for you.

Joyce Charles

Thank you Gia. This helped a lot. I am sorted.

Gia Thinh

I am happy to help.