I’m making a renovation tracker, to keep track of contractors and subcontractors for various tasks during a renovation.
It has three tables:
- a 2Do Kanban board (cards),
- a Companies
table from coda’s CRM template - and the Contactstable also from coda’s CRM template
I want to link the To-Do Kanban board to the Companies table with a Remaining Tasks column. I need it to count only those in the 2Do that meet the following requirements:
- the Company in the Row listed through the Company Contacts (Contact in the 2Do Table)
- the Status is only To-Do or Doing
- each task should only be counted once per Company
Here is the link to the Coda, you can copy it to your own workspace.
This is one of my many attempts: