Can someone please tell me what I am getting wrong

1

Hi Lads and Ladies

I just can’t seem to get my head around the concept of the formulas when referring to another table through a lookup. I’ve followed all of the formula videos online and I still think my formula should work, but it doesn’t.

My logic is:

Select The Checklist Table
Select Checklist item column in table, filter the records that have the “Task name” equivalent of this row’s Task name

However, it’s not working.

I don’t want the actual solution, I just want someone to tell me where my thinking for constructing formulas is wrong.

Capture
Capture.PNG1858×1080 135 KB
Checklist
Checklist.PNG1858×1080 126 KB

2

Please look at the CheckLISTS.Task Name in green inside () - you are pulling out entire column of values and comparing it to thisRow.TaskName.

hint: (as you dont want actual solution)
you already seem to have lookup setup on CheckLists that points back to Task table. if you think of filtering records on CheckLists table where TaskName matches with thisRow you would find a formula that works for your needs. ( when you have a lookup on a table, all values are basically a references to a row from source table like in your case on checkList table, Task Name column contains references to the row from Tasks table as you can see the rectangle around the value.)

1 Like
3

Ok…now I’m getting you.

I’ll try it today and let you know.

Thanks Krunal for not giving me the answer.

1 Like
4

I did it.

So how does Coda treat "."s?

I thought that my previous formula was telling it to look at the entire column but match the rows where the CHECKLIST.TASK NAME = THISTABLE.TASK NAME

Capture.PNG1858×1080 125 KB