I frequently have bank account transactions whose Description is always of the form Check #xxxx: Sh Draft, where xxxx is a four-digit number, and whose Amount is always -$60.00. I tried to create an Autocat rule to set the Category for these transactions. If I set the Amount Min and Amount Max cells…

Just to follow up in case anyone else runs into this problem, the solution is to ensure that the Amount Equals column in the Autocat sheet is using a Number format such as Currency. Thanks to Tiller support for figuring this out.

Autocat Amount Equals not working (or I don't understand it)

Conversation Ask Anything

sskennel January 9, 2021, 3:18am 5

Min and Max are working for me, too. But Equals isn’t.

— Roger

Autocat won't process using "exact amount"

Topic		Replies	Views
Autocat won't process using "exact amount" Google Sheets autocat	9	650	January 15, 2025
Do you use Amount Equals for AutoCat? Conversation	6	150	November 28, 2025
Using Regex Extraction with AutoCat Google Sheets autocat	3	860	February 17, 2021
AutoCat issue with Amount Min and Amount Max Google Sheets troubleshooting	3	733	April 30, 2024
Max/Min amount criteria in autocat works backwards with negative numbers Ask Anything troubleshooting , autocat	4	1005	October 25, 2023

Autocat Amount Equals not working (or I don't understand it)

Related topics