Skip to main content

I have a “Tasks” table with a checkbox (Open OR Complete). I want to list (Rollup) all “Open tasks” in one field and “Complete tasks” in another field on a different table (Clients) What should the formula be?

Hi Charlie, I think you can use a conditional lookup for this instead:







Link to base

Thank you! This should work. However, I have three tables (Projects, tasks, Clients), and the Projects table is the only one I sen link it to. How can I add/select the “Task” table?


Thanks!

This is my formula, but it doesn’t give back any records


This is my formula, but it doesn’t give back any records



Hmm, you’ll need to create 2 conditional Lookup fields in the Projects table that will compile the Open and Complete tasks per project


After that, you’ll just use 2 Lookup fields in the Clients table to display the two fields you just created


I think that should do what you’re looking for

Hmm, you’ll need to create 2 conditional Lookup fields in the Projects table that will compile the Open and Complete tasks per project


After that, you’ll just use 2 Lookup fields in the Clients table to display the two fields you just created


I think that should do what you’re looking for


Thanks, Adam. Fixed it. The wrong field was selected



to display.

Reply


Terms & Conditions