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?