My site's users have an entity reference field in their profile called "Club" where they select which Club they are a member of. Similarly, when creating a Project (a content type) you can select which club created it. I am trying to create a view called "My Club's Projects" which only shows the Projects created by the club the user has selected in their profile.
I am frustrated because when I try to create a Contextual Filter, my only options are to get parameters from the URL or use the ID of the logged in user. There is no option to use a field from the current user's profile as the contextual filter, which is what I want. No matter how many relationships I add, these options do not change. How do I add a contextual filter based on the current user's club, rather than their ID?
EDIT: I've seen many answers that reference a relationship called "Taxonomy term referenced from field_[mytaxonomy]". In my case, I am not using a taxonomy term, but an entity reference; the only available relationship using this field is "Users using field_club_entity_reference". I was hoping to find something like "Content referenced from field_club_entity_reference", but no such relationship exists.
EDIT 2: I've implemented @prkos' suggestions, details of the View setup as follows. It's a View that displays content with type Project.
field_club: Content(the Club entity reference from the Project content type)
(field_club: Content) field_club_entity_reference(the Club entity reference from the User account, using the first relationship)
(field_club_entity_reference) User: Club:target_idwith default value set to User ID from logged-in user.
No other filters other than the standard
Content: Published (= Yes) and
Content: Content type (= Project).
Unfortunately the view still displays no results. It should be displaying two projects for my account since there are two projects that have the same club selected as my account does.