Monday, October 2, 2017

yogi_Pull Calls From Log That Meet Specified Criteria

Google Spreadsheet   Post  #2252

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-02-2017
question by: Sam Larimer
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/IzfqE7AcArg;context-place=forum/docs
Need to filter results based on exclusion arrays (multiple strings)
SPREADSHEET IN QUESTION:

https://docs.google.com/spreadsheets/d/1drwGlcNW4fD56fiEnCrt_kEkDbLvvETygDoIiTiXq4Q/edit?usp=sharing

The title pretty much explains it. I am failing to have a manual import ignore certain strings if a specific contact was called or if the call was not connected. The "exclusion arrays" may change in nature and size.


Initially, I was playing around with the following

=Filter('All Calls'!D3:L50,
'All Calls'!F3:F50<>'All Calls'!A3:A12,
'All Calls'!J3:J50<>'All Calls'!B3:B7)

which clearly does not work as several of the filtered contacts are on the exclusionary array or it eliminates desired results. Feel free to edit space on tab "Location A" and thanks, in advance, for the help.


No comments:

Post a Comment