clean up 'Has Missing' checks