Hi,
Yesterday, my saved splits worked fine. Today it didn’t.
The problem: it’s taking the average (total original number, divided equally be the 42 splits). When I saw that all 42 split categories were the same, I knew something was wrong.
I have:
- made sure my browser is updated (it is)
- refreshed tiller/google sheets
- made sure I wasn’t going crazy and that I had listed the appropriate 42 unique amounts within my Saved Splits sheet.
Any ideas? And thanks! (I can’t imagine doing 42 manually each month…)
@dkushla can you let us know if this is still not working properly?
It seems to now, and I think I figured it out: formatting (or a lack thereof) happened.
I proceeded with the splitting, knowing that I’d have to update all the identical split dollar values into the proper amounts (but at least the categories themselves would populate into Transactions sheet). That’s when I noticed that all my dollar values were left aligned in my transactions sheet which immediately told me Sheets and the splitter wouldn’t know how to process this as numbers.
So I we’re good here.
On a side note, what was odd is that I had copied and pasted from the source values as I always do. Nothing changed with how I did that. AND I always use command+shift paste (mac version of paste without format). So not sure how the source values (formatted in dollars, so they were numbers) somehow ended up as text (or numbers that become left aligned and Sheets doesn’t consider them numbers.)
Thanks for checking in, Heather!
@dkushla thanks for the update here! Glad to hear it’s not a bigger bug we need to address. It could be that the new splitter does something different with the format, but I’m confused about your note
Can you explain your workflow there? With the saved splits I thought you just chose the saved split option from the dropdown in the Split tool and it does all the work for you?
Does this happen every time you use the saved split? The formatting issue I mean? I realize you may not want to re-create this split until the next time it’s needed so just let me know then.
Ah, I use two types of splits: 1) those that are regular monthly splits (eg paycheck splitter) and 2) a list that changes monthly (I use my own version of savings envelopes, so the splitter is splitting the transfer amount from my Savings and divides it up by each envelope it’s pulling from. So I have to go in monthly and update the saved splitter based on that month’s transactions. You just inspired something: I probably should just automate the process with a vlookup for that so I’m not manually doing anything within the saved splitter…