Formula for filtering a list of tasks?

1

Hi, there! Very new to Coda and was wondering if someone could help me with what I think is a formula question. I have successfully created a list of tasks and a list of projects. I was able to successfully create a link between my tasks and projects where my list of projects has a column of all the associated tasks (great!). I’d now like to filter that list of tasks so that no task marked as “done” will show in that list. Here is the formula I’m trying when Coda returns a “misplaced reference” error:

[All Tasks].Filter(And(Projects.Contains(thisRow),Status!=Done))

Can anyone point me in the right direction with what’s wrong in my above formula? Thanks very much!

2

Hi Ryan,

Welcome to the community!

Can you check if this works?
[All Tasks].Filter(And(Projects.Contains(thisRow),Status!="Done"))

If not, in this cases it’s very helpful if you publish a dummy doc (whitout private info) in play mode: Publish your docs to the world | Coda Help Center

Or at the very least paste a screenshot of your formula, there are several graphic elements that give you hints of where the error lies.

1 Like
3

@Pablo_DV This works perfectly. Thank you very much!

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.