Filtering a tasks table

#1

Hey fellow Coda users,

Brainstorming a formula that can get be a filtered view of a tasks table to only show tasks related to projects assigned to a specific user. The projects are assigned/maintained on a separate table.

[Tasks table].filter([project title].matches([project table].[assigned to]=“user”) is one stab i took at it but filter not running, assuming (trying to make myself feel better) syntax is incorrect.

Any one else have an idea on how to get this result?

#2

Hi @Juan_Rey try using Contains instead of matches.

Also, the way i like to debug something like this is by creating a temp. column and starting with the innermost evaluation so and see what it return
[project table].[assigned to]=“user”
then
[project title].matches([project table].[assigned to]=“user”
then
[Tasks table].filter([project title].matches([project table].[assigned to]=“user”)

If you can’t get it to work share the doc with support@coda.io and I’ll jump in.

1 Like