I am struggling with COUNT SELECT rows from another table

[rjtroy]

I have a table/view  CONTACTS
I am logging ISSUES tagged with Contact_ID against  individual Contacts into my ISSUES table
I want to have a column [ISSUES] in my CONTACTS Table showing the numerical count of the ISSUES logged against each Contact

[Aurelien]

Hi @rjtroy 

For future posts, please post in Q&A board, not Tips & Tricks 🙂

1) in ISSUES, set the column Contact_ID with type Ref, source table CONTACT

2) you will see automatically the count of issues logged against each contact on the Contact detail view.

If you wish to see the count directly, you can add a virtual column and use this expression:

COUNT([Related ISSUES])

For reference:

Use virtual columns - AppSheet Help

[rjtroy]

Thank you, Aurelin,
This was my first HELP request - I have noted your comment for the future.
I will play with your suggestions and can I please come back to you for more guidance.
rjtroy

[YvesG]

Hello rjtroy,

If the column "Contact_Id" is a reference to the table "CONTACTS" in the table "ISSUES", there should be a virtual column named "related ISSUESs" in the table CONTACTS.

So the formula  for your new column will be 

COUNT([related ISSUESs])

or 

COUNT(FILTER("ISSUES",[Contact_Id]=[_thisrow]))

or 

COUNT(SELECT(ISSUES[id],[Contact_Id]=[_thisrow]))