Please Help! Realtion column filtered by two matching columns

1

I got off on the wrong foot on another post trying to get some help with a formula that has been incredibly frustrating. So first off apologies for my attitude.

I have used gemini, superhero all recommended the same formula and nothing works. It seems like something that should be incredibly easy, Have one relation column filter by the project its related to and the tag associated with it

in fact this is all I need, I don’t want one or the other but both. project = project and scope tag= scope tag.

19b3cac0b4524414006a333347c4573b300559a2921a309b525e734a9d16c1e93fd37eaaf15030a963290db809d34471c7b0d4444374f2719a9c28b95b3456d4af199284bec6ea250367e4ef47682d2f6a912f8bc1e4143c9008427ec46d5368ae68b937
19b3cac0b4524414006a333347c4573b300559a2921a309b525e734a9d16c1e93fd37eaaf15030a963290db809d34471c7b0d4444374f2719a9c28b95b3456d4af199284bec6ea250367e4ef47682d2f6a912f8bc1e4143c9008427ec46d5368ae68b937275×279 9.08 KB

image
image1397×155 8.83 KB

2 Likes
2

Anybody able to help with this?

1 Like
3

I requested access to your document.

1 Like
4

Thanks just approved your request

1 Like
5

hi, use formula for multi condition

6

Can you elaborate? I’m not very good with formulas, and every formula I used recommended by Gemini and superhuman doesn’t work.

7 
thisrow.project == currentValue.project && thisrow.Scope.. == currentValue.Scope...
8

That didnt work. It doesnt recognize the way you added current row, or the && symbols

image
image575×803 47.1 KB

9

What are you trying to do? Autofill or filtered selection? They’re not the same thing. Right now you’re in default value.

If you have a limited selection, go to filter and custom filter and use this formula.

1 Like
10

Please check your doc.

1 Like