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? [image]

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.

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))

[image] Guide: How to share your doc with the Coda Community Tips and Hacks 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 ver…

[image] Login - Coda Welcome back to Coda. Sign in via Google, Microsoft, Apple, SSO, or enter your email address for a password-free login.

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 b…

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 dif…

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…

Hello @Phil_Purdy1 , I understand your frustration - the learning curve is indeed sometimes a barrier. Most of the time, the problem you are encountering has to do with data types, where an object is compared to a text field. Unfortunately, we can’t determine from a screen print what is going on. …

Hi Joost thanks for taking the time to help out. I made another thread with a dummy doc here: [image] Please Help! Realtion column filtered by two matching columns I got off on the wrong foot on another post trying to get some help with a formula that has be…

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

Phil_Purdy1 November 6, 2025, 1:43am 12

Hi Joost thanks for taking the time to help out.

I made another thread with a dummy doc here:

Topic		Replies	Views
Please Help! Realtion column filtered by two matching columns	9	208	November 7, 2025
Let multiple people filter at the same time	8	1754	June 13, 2022
Formula for filtering a list of tasks?	3	74	February 5, 2025
Auto Filtering Tasks Formula	2	463	February 23, 2023
Use one table to filter another?	12	893	March 3, 2023

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

Related topics