Better Sheets Updates · Lesson 48 of 49

How to Use Smarket

Members-only tutorial

Watch the video and get the practice sheet with membership.

Unlock tutorials
Practice sheet Copy sheet Preview Open Sheet resources unlock with membership.
This video covers how a user would use Smarket to list items to be sold and then unlist those items to be sold. It uses two different forms for the listing and the unlisting. The key connection is that you use a unique number, or a unique text when entering the item to be sold. Then use that item to delist it once it's been sold. Also you can wait 7 days, and the item will be unlisted.
11 formulas linked inline Click any highlighted terms to learn more.

<div> Hi, I'm Andrew of Better sheets.co. I'm here to tell you how to use this sheet. This is Market to Marketplace and a Google Sheet. People can list items describe those items, list a price and a contact information. The people who are selling can also unlist them. And right now the way that this works is that it automatically enlists after seven days.<br><br>Here, let me show you how it works. So I just go to this form. And I'm gonna list name, description, price, and a contact. Okay, so I've listed two pairs of eyeglasses. These are prescription reading glasses for $120. Sheet Makeover - Google Ad Writer How To Sell Google Sheets For Fun And Profit 17 Minutes of Google Sheet Business Ideas

Here's my contact information, Andrew plus better [email protected].<br><br>Here is how you will use this. You have to create an ID that is for unique for this item, what I suggest is actually going to this number generator and generating a nine digit random number that you'll just remember. So here's my number . 7 5 5 6 5 4 2 4 9. It's a random number that no one else will have.<br><br>I'll show you why you need to under have that and remember it. Okay? We immediately are listed. It has two pair of two pairs of glasses. Prescription ring here.

If somebody contacts me I can unlist this how I unlist this. So if I don't have access to this sheet I need to be able to unlist it.<br><br>So here's how I unlist. So now I have to remember the ID that I have, no one else is gonna have access to that Id, it, it doesn't exist here on this sheet. It's on a different sheet if you wanna know. But I put the item in, I submit, and then I go back and it will take it off of the now it's not listed.<br><br>So let's go through that again. One more. So if I want to sell something, I can also put in any idea I want. How To Delete Version History

If I know it's let's do, okay, so I'm listing five wooden chairs here for $45. I put in my contact information and I can honestly put in like anything maybe Andrew 45 chairs $45 chairs for five.<br><br>$5. Four. Five chairs. Anything that I can remember. Again, a no. A random number generator is gonna make it super easy here, but I can submit that. Go back to our marketplace.<br><br>And it's listed here, five wooden chairs. And if I want to, if I wait seven days, it'll automatically go off. You can change that.

If you're using this, you can also check, take a look at how to make the sheet, and I go into how this sheet works and if I wanna sell this, all I have to do is submit there and it'll take it off.<br><br>Reformulates here almost instantaneously. And that's how you have buyers and sellers that don't have to enter any edit anything here. They just enter the information on, sell something. And sold. Make More Money Selling Google Sheets OnlySheets How To Delete Version History

If you are copying this marketplace and you're using yourself your own forms , I would say create your own forms and then change these links cuz these links, once you copy the sheet, will go to my sheet forms .<br><br>But enjoy using s Market the marketplace in a Google sheet. Bye.</div> Roasting Google Sheets How To Sell Google Sheets For Fun And Profit Create Google Form Automatically

Better Than Happy | Redesign of The Feelings Wheel Best Header Font Ever Learn to Love Your Sheets How Starter Story Designs Data Sheet Review! 150 Active VCs by LemonIO Anika Asks: How To Set Text Overflow All The Time Introducing: Brutal Calendar Add a Checkbox to Turn on Dark Mode 00:05:10 Create Drop Shadows! This makes your dashboards pretty. 00:12:04 10 Things I Hate About Your Spreadsheets Merge Cells for Dashboards 00:05:29 Dark Mode / Better Font Color 00:09:35 Better Font Colors 00:02:45 Magical Things You Can do with Checkboxes in Google Sheets 00:12:31 How To Export Your Beautiful Sheets to PDF 00:04:06 Consider Labels as Opposed to Headers 00:04:02 Add Icons To Your Sheets With a Domain Name 00:04:21 How To Color Cell Blocks So Others Enter Data Easily 00:10:30 Great Sheets! Corona Hiring Sheet 00:10:43 Great Sheets! Community Information Board by Seedtable.com 00:07:35 Roast: Hotel PPC Channel Cost Calculator 00:11:25 Better Header Fonts - Best Fonts To Use In Google Sheets Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell 00:09:49 Basic Keyboard Shortcuts To Speed Up Your Productivity 00:13:44 Basics - 5 Ways to Change Row Height 00:05:08 How to Refer to Other Cells - A1 and R1C1 Explained 00:13:22 Anders Asks: Can I Highlight Whole Row if Certain Columns have text? 00:09:31 Change the Default Font 00:03:33 Biggest Flaw In Dashboards with Dark Colors 00:07:45 Basics - 4 Ways to Change Column Width 00:05:48 Basics - Structure of a Sheet: Index() Row() and Column() 00:06:49 Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets 00:08:55 Use Cmd + Y To Do It Again, and Again, and Again 00:03:03 Create an Auto-Update Sales Chart: Trailing 12 Months 00:09:57 Google Sheet Basics - The Absolute Basics 00:09:48 Secure Your Sheets by BetterSheets.co 00:11:07 How To Create An AutoFill in Google Sheets 00:06:07 Build a Thermometer for Savings Goals Make Your Lists Spicy Hot in Google Sheets 00:01:47 Restrict Access to a Cell if Another Cell is Blank How to Use Smarket 00:03:28 Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets! 00:06:23 Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement! 00:53:31