I’ve been trying to do a filtered list option for some time but haven’t been able to figure it out.
Here’s the idea
Table 1 is called Inbox, which uses the headings:
- Project (lookup of Project heading from Table 2)
- Goal (filtered as Project.filter(Project=thisRow.Project).Goal
- Objective (filtered as Project.filter(Project=thisRow.Project AND Goal=thisRow.Goal).Objective ===> this one isn’t working
Table 2 is called Project, which uses the headings:
Any ideas on creating a list that’s filtered based on 2 variables?