Filter by two different fields in one interactive menu?

How To
#1

Hi there,

I’m trying to figure out how to filter a list by two different columns. I’m working with a project list. Each projects has one “lead department” and one or more “resource departments”. These columns both lookup from a “Departments” table. I want to provide an interactive filter to show any project wherein the selected department is contained in the “lead” or “resource” column.

Thanks so much
Tim

#2

Hello @Tim_Richardson1

That is really easy in coda (if I understand you correctly): start by making an interactive control on the first column and then go into the filter options of the table, click on the formula symbol and edit the formula as per my sample.

Greetings,
Joost

PS: copy the doc so you can look at the formula

2 Likes
#3

Thank you for this! It works perfectly in the example you sent me.

For the life of me, I can’t get it to work in my actual coda doc. When I set it up exactly as you did, the select list is totally blank. Not sure what I’m doing wrong!

#4

I will explain later tonight.

#5

@Tim_Richardson1
I have added a step by step explanation in the original doc. This doc now has another page to address another question.

5 Likes
#6

Wow, you are the best. Thank you, Joost!!!