I am trying to set up minimum and maximum amounts in autocat on Google Sheets. I want negative values in amount to be classified one way, positive amounts another.
Currently have minimum amount set to -1, and positive amount set to 1500. That is not working. It is classifying all amounts as though they were positive amounts.
Has anyone had any success trying something like this?
I think I have found my answer. I was trying to change the rules directly in the table rather than using the add rule function. The add rule function allows you to add polarity to the amount, which is what I am after Waiting to see whether it works next month, but for right now, score one for Tiller.
Can’t seem to delete the original topic, so will leave it in case it hits a search for someone.
Thanks for the speedy response.
