I was going through this guide How to Use AutoCat for Tiller Money Feeds sheets | Tiller Help Center and based off the “Description Contains” section, that any words in there would be “or-ed” is there a way to make it an “and” ie i want the description to match all the key words, vs any?

I know this thread is 8 months old but I was running into a similar problem. I suggest to use the Regex feature. For example, on a Zelle transaction, it usually starts with “Zelle” and then ends with someones name, such as Zelle payment from John Doe (Checking XXXXXX1234) to PHIL THE PLUMBER. So wh…

I’m assuming the Multiple Match Criteria means i can have under Description Contain “Starbucks”,coffee"? And that will match with an or? what I mean by “and” is if i have Description Contain “Starbucks”,“coffee” I want the match require both words, not necessarily together in the description.

Yes, “Starbucks”,coffee" would match with an OR. But you could do “Starbucks Coffee”, “Starbucks Wholesale Coffee”, “Starbucks Airport Coffee” to get the key permutations— this would be similar to the approach with discrete rules. If you don’t like the approach :point_up:, you’ll probably need to …

Really appreciate the help, i’ll give it a shot. Main reason for this is I want to make sure that the categorization doesn’t become too catch all, if i use more generic terms vs an actual company’s name. I’ll probably look into regex when I can one example ijust found was Uber Eats, San Franciscoca…

In that case, I don’t understand why you don’t just use “Uber Eats” as your contains term… As for the regex, you can setup OR statements with those… or you can make them flexible like you show in your example. I’m not an expert.

The uber eat’s was probably not the most encompassing example. Maybe: “Walmart Plus” to code as subscription vs other items from Walmart to code as other items. Unless AutoCat runs first by top down list in the autocat tab then I guess having the “Walmart Plus” first would categorize those first and…

Thanks that’s what I ended up doing. But it seems i need to find a way to get an and feature, ie one regex i did was to find att, but that sometimes grabbed things others than phone services. and putting it at the bottom of the list doesn’t always help because sometimes it wouldn’t fit any other aut…

I would like to use a regex to match two strings in any order (as an AND match) while being case insensitive so I can match with merchants that mix up their capitalization in a transaction description. For example, if I do the regex (?i)foo.*bar|bar.*foo inside the =REGEXMATCH Google Sheets formula …

Looks like the same question in two different topics. [image] What Is Your Favorite AutoCat Regex? Discussion What is the error message? Also a note from the original post:

How is this new Regex column connected to the Name and category columns so it functions correctly? Is the existing Full Description column kept or replaced? Sorry… im a rookie

How to Use AutoCat for Tiller Money Feeds sheets | Tiller Help Center check regex section in that link so it’ll be like Add a column name and append the Regex suffix to it to build rules using regular expressions. E.g. the column in the AutoCat sheet would be “Description Regex” or “Account Rege…

Autocat Contains Search Terms

Spreadsheets Google Sheets

Mark.S March 15, 2024, 9:36pm 11

Looks like the same question in two different topics.

Topic		Replies	Views
What Is Your Favorite AutoCat Regex? Conversation autocat	40	2949	November 19, 2025
Autocat and Descriptions Ask Anything	4	110	September 16, 2025
Using RegEx with AutoCat Google Sheets how-to , autocat	31	3154	December 12, 2023
Autocat advanced rules (contains this when not that) Google Sheets autocat , regex	3	900	September 5, 2022
Autocat rule question Ask Anything	4	349	January 22, 2023

Autocat Contains Search Terms

Related topics