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.