search column – Update the item option selection based on another list

I am relatively new to all this, so I apologize if this is simply not possible or is incredibly easy.

I have two lists, the first one is & # 39; Projects & # 39 ;, which is a list of several projects that are being worked on, and another list is & # 39; Clients & # 39 ;, which is a list of clients that I have. One of the columns & # 39; Projects & # 39; It is a Search for & # 39; Clients & # 39 ;, to define for which client the project is.

Within the list & # 39; Client & # 39; There is another column called Pipeline, with a "yes" or "No" option. I want the column & # 39; Pipeline & # 39; be updated based on whether there are projects in the list of & # 39; Projects & # 39 ;.

To add a complication level, once a project has been completed in the list & # 39; Projects & # 39 ;, it is not deleted, but the column & # 39; Status & # 39; is set to "✕" to "✓". I just want the column & # 39; Pipeline & # 39; in & # 39; Customers & # 39; show that there are projects if they are "✕", that is. Unfilled.

This is how the List of & # 39; Projects & # 39 ;:
Sample project list

This is what the List of & # 39; Customers & # 39 ;:
Customer List Example

Let me know if this is possible!

Thank you,

Nathan