find records automation not finding by name

[cori_parrish1]

this is probably the dumbest question.

i have a table with a list of organizations (Members table) and a single-select field that tells me whether they are members or not.

i have another table with a list of organizations that have sent someone to a training (All Orgs table).

i made an automation triggered by when a new organization is added to the All Orgs table to search for that org by name in the Members table and update a field in the All Orgs table to indicate if the org is a member.

when i test the automation, it finds zero records, even where i can see that the orgs are in both tables. the condition i am using is:

Where 'trim org name' contains 'trim org name'

'trim org name' are formula fields i made in both tables, just in case there are extra spaces in the org name fields that would make the find fail.

what am i missing?? i'm guessing it's something so obvious. thank you!

[TheTimeSavingCo · Accepted solution]

Hm that's a weird one, just tried it out and seems to work for me.  Could you try re-testing your trigger perhaps?

If that doesn't help, could you provide some screenshots of your tables with the relevant fields and the automation setup?

[cori_parrish1]

thank you so much for your reply! because you said it should work, i went back & copied data out of the matching fields & pasted them into another doc, to make sure they were identical. turns out my import had added weird spaces between some of the words, so that was making the find fail. it is working now!