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	564	January 15, 2025
AutoCat and Min/Max Amount Google Sheets	5	190	October 1, 2024
AutoCat Min Max don't work as expected for negative values Google Sheets troubleshooting	3	53	February 24, 2025
Autocat Min and Max not working as expected Microsoft Excel	6	614	February 7, 2023
AutoCat issue with Amount Min and Amount Max Google Sheets troubleshooting	3	715	April 30, 2024

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

Related topics