Roolup and list "Complete" tasks

[Charlie_Pesti]

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?

[TheTimeSavingCo]

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

Link to base

[Charlie_Pesti]

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!

[Charlie_Pesti]

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

[TheTimeSavingCo]

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

[Charlie_Pesti · Accepted solution]

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

to display.