Formula or Multi row

[leelak]

Hi Team, I have three columns lets say Name, Count of duplicate and Moved to tracker (Yes/No).

Requirement: If count of duplicate is 1 then Moved to tracker as "Yes" and If count of duplicate is >1 Moved to tracker as "No"

Description: Let say initially Name = "Leela" so count of duplicate = "1" as per my formula Moved to tracker coming as "Yes". When new entry Leela comes, count of duplicate for both the names = "2" as per my formula for both the names moved to tracker coming as "No" as count of duplicate became >1. I want that first one "Leela" should be remain as "Yes" and the new entry should be "No" in Moved to tracker column.

What is the way to overcome this issue?

[FinnCharlton]

Hi @leelak , This workflow should help you out:

[RobertOdera]

Hi, @leelak 

Please check out the below.

Please mark it as an acceptable solution if it works for you.

Cheers!