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?
Solved
Roolup and list "Complete" tasks
Best answer by Charlie_Pesti
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.
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!
+31This 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.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.