I have 150 clients who have bi-weekly changing account balances and who each have their own google sheet to keep track of their updated data. The way their balances change is by percentage and generally it's the same percentage alteration only a different percentage each time. For example, this week all of the clients had a 4% increase in their balances across the board. So what I generally would do is painstakingly work out one by one 4% of each client's balance and add that to their total balance and go into their sheet and manually update this to get their total balance. Also enter other details like the date.. in their sheet to be reflected on a graph. This has only taken a few hours or so twice a week until recently but suddenly the client base has begun to explode and I'm really looking for a way (if there even is one) to automate as much of what I have to do as possible in order to speed things up. At 500 clients obviously the way I'm doing it now will quickly become a whole lot of work. Not being familiar with app script or any formulas or anything like that I was wondering if there might be a way to at least have a formula in place to automatically work out and change a percentage addition (or subtraction) to a cell(s) to save me having to do the maths each time. Or is what I'm asking impossible because the percentages are changing every time? My thinking was if there was a formula or script in place I could go into that script and change the percentage to be worked out appropriately each time and the rest would happen in an automated way.
As you have probably gathered I'm well out of my depth Thought I'd ask though because you guys have been so helpful before.
Bookmarks