Skip to content
English
Go to timetoreply.com
  • There are no suggestions because the search field is empty.

Using filters to exclude data

Learn how to apply filters in timetoreply to exclude irrelevant data and focus on the most important insights.

📊 Step-by-Step in Google Sheets

1. Open your spreadsheet

Let’s say your sender addresses are in Column B (starting from B2).

2. Create a new column next to it called Sender Type

3. Use this formula to classify the sender

Paste this formula into the first cell under Sender Type (e.g., C2):

excel

CopyEdit

=IF(REGEXMATCH(LOWER(B2), "noreply|no-reply|do-not-reply|notification|automated"), "System Notification",

 IF(REGEXMATCH(LOWER(B2), "linkedin"), "LinkedIn",

 IF(REGEXMATCH(LOWER(B2), "newsletter|digest|updates|info@|news@"), "Newsletter",

 IF(REGEXMATCH(LOWER(B2), "free|winner|claim|congratulations|promo"), "Spam",

 "Other"))))

4. Drag the formula down

Click the little square on the bottom-right of the cell and drag it down to apply it to all rows.

🔍 What this does:

  • LOWER(B2) makes everything lowercase (to avoid case mismatches).

  • REGEXMATCH looks for specific patterns (like "noreply" or "info@").

  • It then labels them as:
    • System Notification

    • LinkedIn

    • Newsletter

    • Spam

    • Or Other (likely a real person)

✅ Bonus Tips

  • Want to filter out all the skewed entries? Just filter the Sender Type column to exclude “Other”.
  • Want to create your own rules? Add more terms in the REGEXMATCH function like this: newsletter|digest|info@|weekly.

For more information on timetoreply filters, please refer to the below Help Center articles: