Change Status Ball for Old Row Entry When New Entry of Same Name is Created

Jeremy Pittman

Capture.PNG

I have a sheet tracking facility access qualifications for contractors; I need to change the status ball for a previous entry when a new row is created of the same contractor. Basically, when "Ron Cook" has a new row entry, change the status ball on the previous "Ron Cook entry to trigger automation to move the old row to an archive sheet. Please assist. Thanks.

Paul H

Not sure what date you want to use, but something like this

=IF([Start Date]@row = MAX(COLLECT([Start Date]:[Start Date], [1) Employee Name 1]:[1) Employee Name 1], [1) Employee Name 1]@row)), "Green", "Red")

Paul H

Not sure what date you want to use, but something like this

=IF([Start Date]@row = MAX(COLLECT([Start Date]:[Start Date], [1) Employee Name 1]:[1) Employee Name 1], [1) Employee Name 1]@row)), "Green", "Red")

Jeremy Pittman

Perfect. Exactly what I needed. Thanks!