1

I'm struggling to find a list of conatcts with no activity records, could someone help me on how to achieve this?

3

Use search builder to search for all contacts with the activity field: activity date of "not null" and add them to new group "has activities". Use the include/exclude custom search to find any contact not in the "has activities group and add them to a new group "no activities".

1
  • That's pretty good. – Demerit Mar 4 '20 at 17:01
0

You could export a list of contacts, export a list of activities, and then using vlookup() in excel find the rows in the contact list that do not appear in the list of activities.

See e.g. https://www.extendoffice.com/documents/excel/3124-excel-compare-two-columns-for-missing-values.html#formula where it says "Compare two columns for (highlighting) missing values with formulas"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.