I’ve been away from glide for a little bit and came back to work on a project. For some reason it’s like starting from new.
I have the following sheets. Challenges and challengePlay respectively
What I want to do is get the value of P1CollectibleID from the challengePlay into the P1CollectibleID in the Challenges sheet using array formula.
The criteria is to get the P1CollectibleID that matches same ChallengeID and P1(email address)
To give a bit of context, users challenge someone by creating a challenge, and then once the challenge is created both users can play. Challenges are created in the challenges sheet and their plays are created in the challengesPlay sheet.