Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formula to find and label duplicated (question bank)

Topic Labels: Data Formulas
618 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Musaab_R
5 - Automation Enthusiast
5 - Automation Enthusiast

Screen Shot 2023-03-08 at 9.59.33 AM.png

Hi

I've more than 10,000 questions and counting, and many questions added daily, the issue is finding and labeling then deleting the duplicate, duplicate are not exactly unique same question written with similar words but different context , and sometimes exactly the same but with extra word.

i used the 2 duplicate extensions and it is very useful but it need too much manual work (see attachment )

so my question, what Formula can i use to label any question in separate column and flag the question as duplicate and linking the duplicate form with lookup/rollup, so i could ? 

i wish the result to be like that .

 

Screen Shot 2023-03-08 at 10.21.16 AM.png

thank you , i will really appreciate your answers.

1 Reply 1
Musaab_R
5 - Automation Enthusiast
5 - Automation Enthusiast

anyone ?