If EXCLUDE appears against every profile in the ‘To Exclude’ sheet of your Activity Workbook, read this
A problem we are continually dealing with is external providers (such as LinkedIn and Phantombuster) changing things that affect our operations.
An example of this is the “results” CSV file produced by Phantombuster contains the LinkedIn url in a different format to that which was previously provided!
This can cause EXCLUDED to appear against every row in the “To Connect” sheet of your Activity Workbook
The Fix
Copy the following formula (or copy it from the relevant cell in a freshly downloaded Activity Workbook)
=arrayformula(if(isblank(C3:C),,if(isna(vlookup(if(iserr(find(“?”,C3:C)),”*”&C3:C&”*”,”*”&left(C3:C,find(“?”,C3:C)-1)&”*”),AA:AA,1,false)),,”EXCLUDE”)))
And paste it as follows (into Cell B3)
This replacement formula deals with a variety of potential URL formats!
If your LinkedIn Search Filters are “greyed out”, read this
The LinkedIn techies seem to often “fiddle with the dials”!
As a result things often don’t work well for a while and we have to find “workarounds”.
One recent example of this that you may encounter when you next try to do a Search in LinkedIn is that the Filters are “greyed out”.
Following are some screenshots showing the problem and what to do about it:
