How many rows a contact is entered in a sheet?
Hello! I am trying to count how many rows a contact is entered in a sheet. Do I create a summary field?
I am using this formula for my text/number summary fields to count each status (for a report that I am using in a dashboard): =COUNTIF(Status:Status, "Purchased"). Status is a text field.
What summary field type and formula do I use to count each contact (so that I can add an Assigned To report to a dashboard)? Assigned To is a contact field.
For example, I want to add a report to my dashboard showing the number of items assigned to each contact.
Example of rows in sheet:
Example of report from data above: