How to make my notes match both a tag and a project?

[Phil_Purdy1]

Hi this is probably pretty simple but I cant get it to work.

All I want to do is have the job notes show only the job notes that belong to the project and have the same scope tag. What does that formula look like?

[joost_mineur]

You have to filter the Job Notes column. If you share a (dummy) doc, it is a lot easier to share the correct formula with you.

[Phil_Purdy1]

How do I share a dummy doc?

[Phil_Purdy1]

I used this filter I got from Gemini and it seems close to what I want but it doesn’t work

Job Notes.Filter(Projects.Contains(thisRow) AND Scope Tag.Contains(thisRow.Scope Tag))

[anon1959570]

Guide: How to share your doc with the Coda Community

TL;DR Guide (especially for new Coda-Users): How to share your doc with the Coda Community. Just copy and paste it into all topics where there is insufficient information. Long version: Hello folks, This is my first post in this category. I don’t think this post has much added value, but I decided to publish it here anyway. In the last months, I have often seen that new users, in particular, need help, but are not aware that it is extremely important for us to share their document, add a…

[Phil_Purdy1]

Login - Coda

[Phil_Purdy1]

I sent the link but I dont know how to not include all the data, which is annoying because I really dont want to share this with customer data in it.

I decided to delete the link, Im not going to share my doc without keeping the data I want out.

I feel like this should be a really simple formula but nobody is responding

[Pablo_DV]

Sir, you are way out of line.

Joost and Christian are volunteers who help people like you in their free time. They have solved hundreds of questions, so have you considered that you are not making it easy at all?

Make a copy of your doc, remove sensitive data and share it. It’s really not that difficult.

[Phil_Purdy1]

Sorry but my doc is loaded with sensitive data and deleting it all will take a really long time.

All I want is the column to filter for both below. Thats it, I’m just really frustrated I cant get it to work and I’m not getting anywhere. This is just a sample of how frustrating of an experience coda can be for people outside of the coding world.