You have a full syntax and a compact syntax and, as far as I can tell, the compact syntax does not work with multi-word labels. If any message in the thread is labeled, that’s good enough because I’ll find the conversation via the label.īut if you want to find not unlabelled threads, but all unlabeled individual messages, then you need to do as Danimal says. I like leaving conversation mode on because I generally want to catch only entire conversations with no labeled messages at all. With all methods, Danimal suggests turning off conversation mode (threaded conversations) as that can make things confusing. And there you go - you should have every single label negated in one giant filter. In TEXTJOIN we set the second parameter to TRUE so that if there are any empty rows, they get skipped. So finally, you have to add ( CONCATENATE) to the front your initial “-label:” (note lack of leading space).
Since this does not “join” anything to the front, you’re missing one label and we wouldn’t want the leading space in there anyway. Then you TEXTJOIN each cell, using ” -label:” as the joining text (note the leading space on ” -label”). =CONCATENATE("-label:", TEXTJOIN(" -label:", TRUE, ARRAYFORMULA(SUBSTITUTE(LOWER(A1:A100), " ", "-"))))īasically, working from the inside out, you LOWERcase your labels and SUBSTITUTE hyphens for spaces across the whole range (i.e. Assuming that your labels are in cells A1:A100, your Google Sheets formula would look like this: You can actually do this in one line with no cut and paste. Then I simply used the formula = CONCATENATE to make the “-label:” part then another =CONCATENATE to merge them into a usable string. Then copied and pasted into a new column so I could find spaces in my labels and replace with dashes (-). You can also do things like rename your labels and move a child label to another parent.Ĭhris describes how he uses this to put the labels into a format that is usable in filters:įor example, once I had all of my labels in a column, I put them in lowercase with the =lower formula. Basically, it lets you connect your Gmail or GSuite account to a Google Sheet and pull all labels into a spreadsheet. Thanks to commenter Chris who alerted me to a new Google Sheets Add-On called Labels Manager. Label ALL of the results with a new “LABELED” label (or whatever you want).First search for every message that HAS a label ( has:userlabels).Method 4 - Desperate Measuresįinally, if all else fails, you can use this roundabout method from Federico (comment from ):
So what I’ve done is simply create a shortcut (aka bookmark), which you can do quite easily and it works up until you add a new label, but then it’s just a simple matter of editing the bookmark. If you do this more than once, typing in all your labels in the arcane syntax Gmail uses gets old. -label: -label:label-three -label:label-four -in:sent -in:chat -in:inbox.Method 3 - Highly reliable but a pain in the butt.has:nouserlabels -in:sent -in:chat -in:draft -in:inbox.Method 2 - Simple but doesn’t work for everyone.-has:userlabels -in:sent -in:chat -in:draft -in:inbox.
#GMAIL SHORTCUTS DATE SEARCH FILTERS UPDATE#
This is a pretty long article, so I’ve organized this article into sections - click any link below to jump directly to the section that solves your problem. (NOTE: I update these periodically to incorporate new user comments.)īelow the links is a Prefaceon my original motivation and my current feeling about labeling or not. But you don’t want to wade through the whole set of emails manually, right?Ī little filter magic will sort this out in no time. So how do you find GMail message with no label? It will include a lot of email threads with labels. Unfortunately, this still doesn’t work reliably for me (updated March 2019). So you want to find unlabeled GMail messages.Įasy, right? You just search on has:nouserlabels (see Method 2 below). Maybe you need to clean out a bunch of cruft and your unlabeled email is usually not important. You want all your GMail messages to have a label, maybe several.
0 kommentar(er)
