I have a database which tracks calls. Each row designates one call received by the representative.
Each call must be filtered into 5 seperate categories. I'm thinking I can give the rep the option to select a category, then I had another idea:
How would I setup keywords to 'read' the cell where the call notes are stored, searching for specific keywords, and if found, designate the proper call type? For example, one of our call types is Billing Question, If the word "billing" or "bill" or "bill" and "submit" or "bill" and "request" is in the body of the cell containing the notes, I want another cell, call it (AF,1) to respond by returning 'TRUE' Any Ideas?