Got this question in the Facebook Group: How to count the number of numbers in a row. I saw two possible solutions mentioned in the comments and wanted to go through why those are okay but there is a much more flexible and better solution.
I created a weight loss tracker template for myself and thought you, and all members would like it. So get it, copy it, and start your weight loss journey today. Comes with a nice chart already so all you have to do is add your numbers every day.
Let me tell about some cool hacks you can do with checkboxes. Like making a checkbox have alternative values, or making a checkbox look like a button, not a check mark.
Create rounded pill form fields in Google Sheets.Using Canva and a bit of a transparent PNG hack, you can make these very easily too!also make sure to check out Coupon Code Maker a software product I sell that generates thousands of coupon codes in a click.Recently updated dashboard makes it really cool!
Update to Coupon Code MakerAvailable for free for lifetime members. Buy via Gumroad if you're not yet a member.Watch the video because there are discount codes I show you in the video to get Coupon Code Maker for less than $30. Yes I use Coupon Code Maker myself. It's how I put products from Gumroad onto AppSumo Marketplace.
What is "&" doing in this formula? MONTH(A1&1)Do you know why this is so cool? It can replace an entire vlookup chart I've been making for years.
In my video, I talk about how common problems are and how Google Sheets can help solve many of them in business. I discuss the different ways Google Sheets can be used, from simple to complex tasks, and plan to share five specific ways to use it effectively in future videos for better planning, tracking, and managing tasks.
Get the spreadsheet for free: https://kampheyapproved.gumroad.com/l/100ways100subs/sellingspreadsheetsWatch how to make a Bookmarklet video: https://bettersheets.co/tutorials/let-s-make-a-bookmarklet
I'm breaking down the landing page of titlecraft master nonfiction book titles. It's by two people I know on Twitter, and they send this to me and it's free, it's zero dollars
How to think about the context, psychological state, of your customer, so that you can sell them a solution.
Scope down from an existing problem to a sheet that still solves a juicy problem. If you can solve something in 10x less time, you win. Find out how lack of specificity is the #1 mistake. I’ll share with you a quick way to figure out if you’re really saving people time.
Figure out the framework to consistently come up with spreadsheet-able ideas and make them super easy to execute from your laptop.
A few things that surprised me when I started selling sheets. From landing page copy that converts, to what people want to know after they buy.- Adding videos to onboard helps immensely.- Landing page copy should agitate, not solve everything.- Sheets aren’t sold, they’re bought.- Selling a great sheet is selling a great process.- You can Launch, again and again… seemingly forever.