Automation condition equal to (find and replace) ?

Kimbh

Hi, I have a sheet with information on if an inspection has passed or failed. If an inspection has failed then a new row is added to the sheet saying the inspection has passed then I want the failed row to be deleted. I want the automation to find the matching part number. This is a sheet that is being updated daily so I need a way file the automation to search for which part number to change. Any thoughts on how to make this work. Thank you

Christian G.

You can use "helpers" column, and have an automation that will (re)move the failed row to the to an archive sheet.

the helper column would set a checkbox to True if the same part number with a pass exist.

=if(and([test]@row="Failed",count(collect([part]:[part],[test]:[test],"Passed".[part]:[part],=[part]@row))),1,0)

if you put this to a checkbox column, it should checked every "failed" tests for a part that had a "Passed" . You cnat then use a automation to move those row to another sheet.