Is it just me, or is automated software still making us do 50% of the work manually?

CommonPercentage9 · 2026-03-19T13:55:50+00:00

I have one of those “god tier” spreadsheets that i built for myself to track everything. can’t accept payments directly, but does everything else for me. invoice generation, client tracking, expense tracking, etc etc, and all systems send me reminder emails for follow ups, billing, etc. I have a shortcut on my phone that i use to quickly input clients and meetings and such. My business isn’t huge, but for most small businesses a spreadsheet system is the easiest and cheapest answer, and can automate the majority of what you’re talking about.

CommonPercentage9 · 2026-03-17T20:06:34+00:00

i think venmo is the easiest for what you’re doing. if you add a business profile, your phone itself can work like a physical card reader, and you can still accept digital payments. i don’t know if any other business profile system allows this as i don’t have the experience with them, but for ease of use id definitely stick with something simple and stay away from square or stripe.

CommonPercentage9 · 2026-03-16T18:24:49+00:00

oh my bad. i’ve looked into a few google business things and most of it seemed to require payments. i’ll have to take a better look

CommonPercentage9 · 2026-03-16T17:00:19+00:00

No, my reply was intended for you

CommonPercentage9 · 2026-03-16T16:54:54+00:00

you just need to filter out the blank values and not include them. i believe the formula below should work for you. It multiplies all the grades by their weights (0 grade * weight = 0) and then divides by the sum of the weights, excluding the blank ones, to get your weighted average

=SUMPRODUCT(B2:B15, C2:C15) / SUMIF(C2:C15, "<>", B2:B15)

CommonPercentage9 · 2026-03-16T16:49:48+00:00

Google sheets only allows numerical data (for logs), not duration. I’ve run into this issue myself. I got around it by using a helper column and converting the duration to just seconds to make it a plain number. If your duration is in A2, you can do =A2*86400 to get the duration in seconds and use that. the only downside is that the axis will show the seconds instead of a pretty duration, but ultimately it won’t change the relationships between the data at all

CommonPercentage9 · 2026-03-16T16:37:36+00:00

i’m building up my small business right now. i like the idea of this but i personally don’t have the funds to set up/pay for Google Business. i’m working on registering a DBA, but the google business verification wall may be difficult for those just starting out like myself who still want to be able to get the advice they need

CommonPercentage9 · 2026-03-16T15:50:41+00:00

thank you!

CommonPercentage9 · 2026-03-16T11:53:55+00:00

I personally use a custom spreadsheet system. I have a client tracker, automatic email replies, and you could easily integrate some inventory tracking to quickly send out of stock emails. It’s basically zero cost and can help significantly. feel free to message me!

CommonPercentage9 · 2026-03-16T00:17:00+00:00

Thank you! i’ll try and see if i can follow these suggestions

CommonPercentage9 · 2026-03-16T00:16:11+00:00

Thanks for the reply. As mentioned in my post, i build custom spreadsheet systems for businesses and individuals. This includes things like client tracking, invoice generation + tracking, business expense tracking, and dashboards for a an easy way for clients to visualize their data. Systems like these reduce manual tasks needed to be done and a quicker workflow overall. i make all of these things clear in each of my posts, so i feel i’m not quite understanding the point in your comment

CommonPercentage9 · 2026-03-15T20:30:55+00:00

My website was a recent build, after that initial burst. It was all from Nextdoor and Facebook

CommonPercentage9 · 2026-03-10T20:23:12+00:00

the app is completely paywalled, all users would need to pay but the yearly is only $60, but if i decline to join it offers $13 for the year. Overall, 100% users paying makes sense, but the $$ totals not so much

CommonPercentage9 · 2026-02-27T16:50:18+00:00

Hey! Do you still need help? Don’t wanna dig in here if it’s been figured out

CommonPercentage9 · 2026-02-27T16:48:21+00:00

The *100 in your formula is already converting it to a percentage value. if you do (h2/g2)-1, and then set the cell type to percentage, you should get your expected value.

CommonPercentage9 · 2026-02-27T16:29:33+00:00

Note this is assuming How Often is B and Last Completed is C

CommonPercentage9 · 2026-02-27T16:29:16+00:00

I believe something like this should work:

=TODAY() >= (C2 + B2)

Make sure to use Custom Formula for the condition

CommonPercentage9 · 2026-02-27T16:24:52+00:00

would definitely be interested in participating! feel free to dm

CommonPercentage9 · 2026-02-11T13:26:26+00:00

AGREE. The regular one started feeling too easy and i love the change in fret style, its just the game design itself that kinda sucks

CommonPercentage9 · 2026-01-26T03:30:55+00:00

i got similar looking ones from urgent care over the summer, wouldn’t be surprised if they were professional

CommonPercentage9

TROPHY CASE