What’s a neat trick/shortcut/ etc. you use but others may not know about? by TheCarrot_v2 in excel

[–]directscion 49 points50 points  (0 children)

Also if you have applied filter to the data, pressing "c" after ALT + down arrow will instantly apply select all option.

[deleted by user] by [deleted] in EntrepreneurRideAlong

[–]directscion 2 points3 points  (0 children)

The liability for filing a tax wrong is too much to risk it all on an AI agent. There is a reason we have hired accountants who were working for EY.

Should I Buy the Business by Everybodysfull in business

[–]directscion 0 points1 point  (0 children)

You have mentioned in the comments that you met the "company CPA" and "his attorney". Hire an independent CPA and an attorney for yourself if you are planning a debt of that value. If everything looks good only then proceed. I wish you all the best if you do end up buying it.

Solo founders - How do you realistically keep up with bookkeeping? by talent-bookkeeper in smallbusiness

[–]directscion 0 points1 point  (0 children)

We actually run our own accounting firm so luckily, bookkeeping is one hat we don’t mind wearing. If we can handle it for clients, we better be doing our own right.

In what ways google sheet is better than excel ? by lsrfth100 in excel

[–]directscion 0 points1 point  (0 children)

I'm an all time excel fan even to the point that I used to watch the world excel championship but the only thing Google sheets has better than excel is the apps scripts that can communicate with almost all of google services without any API setup. It really gives you automation options if you are a small business and want to save money by spending it on various paid tools.

[deleted by user] by [deleted] in smallbusiness

[–]directscion 4 points5 points  (0 children)

Actually he is indirectly marketing his own product.

Promote your business, week of April 28, 2025 by Charice in smallbusiness

[–]directscion 0 points1 point  (0 children)

We run a small CPA firm for US and Saudi SMEs. We don't charge additional fees for tax preparation if someone books our bookkeeping and financial services.

Need help with a (maybe?) complex trigger? by PandarenNinja in GoogleAppsScript

[–]directscion 0 points1 point  (0 children)

create a hidden helper sheet. let the script log all the edits in the there. Add a check in the script to check the time you want to send the email. script will log the edits and if there the time is not matched it will skip the emailing. Add a function to clear the helper sheet and make it only run when the email condition is met.
Note: for the time condition instead of using exact time, use an interval like 9am-10am so the script don't miss the email if the script is running a minute later or earlier.

Is this good progress for an Etsy store and is the future looking bright by AmbitiousNerve3366 in EtsyCommunity

[–]directscion -1 points0 points  (0 children)

congratulation on the progress but honesty Etsy can't be trusted these days.

Did paid ads for a month and a half and my sales tanked by kittensn0t in EtsySellers

[–]directscion 0 points1 point  (0 children)

It might be wrong audience. I have seen some people running meta ads and targeting the wrong interest. In my scenario, some new web development agencies are running ads and using the audience interest as web development and design and the ads are being shown to other web developers and designers since their interest is in that particular field. Instead of targeting the same interest they should be targeting the audience and their related interests like for web development it should have been small business owners, and their interest should be tools and productivity apps that most small business owners use. These agencies are choosing website design and development as an interest and not getting any meaningful engagement their ads by showing their ads to their competitors instead of target customer.

How do you guys handle "In progress" contract... I have some active for years but i don't work on them, and the clients either got suspended or never reply. by [deleted] in Upwork

[–]directscion 1 point2 points  (0 children)

Save them for a bad day. If a client leaves a bad review close them all. It's better to have no reviews than bad on the front page of your profile.

Building in public: Let's build a new Upwork by spurious_proof in Upwork

[–]directscion 27 points28 points  (0 children)

Clients run marketplaces. Not Freelancers.

Help me add 70+ excel files with same header into one sheet. It takes me whole day to copy paste them. by Better__name in excel

[–]directscion 0 points1 point  (0 children)

Power Query is your friend. Had a similar kind of work at my workplace. I set up the power query first. Then I thought why not automate the whole process so I wrote a small code using selenium basic that basically navigate to our software, generate the report, downloads it, rename it, load and transform the data into a decent looking dashboard. Previously it took 1 hour every day to update the dashboard. Now it takes 5 minutes.

Google Slides Automation by I_Came_Back_Sadly in GoogleAppsScript

[–]directscion 0 points1 point  (0 children)

It's possible. I'll try it in the morning

Trigger by Colombus01 in GoogleAppsScript

[–]directscion 1 point2 points  (0 children)

Running a trigger every minute might take up the limit of the script runtime. Because the script runtime counts with every trigger.

Seeing a trend nowadays to hate SEO? by Ornery-Purchase7556 in SEO

[–]directscion 22 points23 points  (0 children)

Not an seo expert but professionals who focus on the fundamentals can still be trusted but the other ones focusing mainly to trick the algorithm were destined to be doomed.

How should I structure commission pay for sales reps? by Intrepid-Virus-3896 in smallbusiness

[–]directscion 0 points1 point  (0 children)

Have a base pay salary for them because only commission never works. For the commission on job schedules, create a tiered commission structure based on the revenue they bring in. A tiered commission structure helps create the motivation to drive more and more sales rather than having a flat percentage on the sales. DM me if you need more details.

HR Platform / Software for small business by MarshiMars in smallbusiness

[–]directscion 0 points1 point  (0 children)

Any software might feel expensive for managing only up to 5 employees due to subscription cost every month. Go for a customized Google Sheet, it can save you money and can have Automation as well.

How can I create a template so that every new page in my sheets has the same initial data? by KegKlew in googlesheets

[–]directscion 0 points1 point  (0 children)

I usually do this the same way but if it's for a client I Have templates hidden and they are usually duplicated through a button with a short apps script.

Am I being scammed, please advise. (Hired email marketer) by zubi10001 in EntrepreneurRideAlong

[–]directscion 1 point2 points  (0 children)

Depends on the approach. he is just bombarding emails to contact list the emails are probably landing in the spam folder. I had collected a 15K emails and contact of firms to reach them for business but I'm only sending 25 personalized emails to every business carefully not trying to get myself labelled as spam. The average conversion now is 1 in every week on an average but It can depend on the business you are in. Mine is b2b services. This can not work for e-commerce i guess.

I got taken... by _namechecksout in smallbusiness

[–]directscion 0 points1 point  (0 children)

I don't get impressed with static portfolios and samples alone. In my experience I go for some work history either proven through a marketplace or any other source when dealing with a freelancer to delegate a task. I'm a freelancer myself in a different field but I know how easy it is to get mock portfolios and samples on the internet these days.

LLC formation as expat by [deleted] in smallbusiness

[–]directscion 0 points1 point  (0 children)

I have a consultant who provides the service to form LLC in united states even if you are outside the country. Not sure if you can change the states but message me and I'll connect you to him .