I have three tables: Projects, Tasks and Weekly Goals
I group my tasks by project and then when i am planning my weekly goals I am thinking through them by project. Therefore, I have been logging tasks all week by project. When I then plan my week, I want to be able to only select tasks in a lookup/relation that correspond to the project that I select in the weekly goal I feel like this is a pretty simple use case shared in the attached doc:: Filtering Select Lists | Coda Help Center
I cannot get this to work. It shows all of the tasks in the tasks table instead of the tasks that have the same project as defined in the Weekly table
My formula for the Tasks field in the Weekly Goals table is: Tasks.Filter(thisRow.Projects=Tasks.Projects).Name
Thank