how to set up automation logic for move row based on field value
I have a sheet populated by a form evaluating items identified by #'s. . There are several hundred items to be evaluated and users may fill out this form several times a year. My goal is to have the sheet showing only the most recent evaluation for each item.
I would like to create an automation so that each subsequent time they fill out the form for item #XXXX, the row containing the previous form entry for item #XXXX is moved to another sheet.
I am not sure how to set up the trigger block logic for this.
I am starting with
When Rows Are Added and Run Work Flow When Triggered
But I need to add a condition where "when the item # matches an existing one, move the oldest entry to new sheet"
but there is no option for "matches." The closest I can find is "is equal to" but I don't have a way to specify the number.
Also the "Move Row" action does not allow me to specify the older row should be moved.
Any suggestions would be very appreciated.