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)

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	549	January 15, 2025
AutoCat and Min/Max Amount Google Sheets	5	167	October 1, 2024
Autocat Min and Max not working as expected Microsoft Excel	6	606	February 7, 2023
AutoCat issue with Amount Min and Amount Max Google Sheets troubleshooting	3	707	April 30, 2024
Autocat Not Overriding Amount Ask Anything autocat	12	389	January 15, 2025

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

Related topics