Revamp Your INVENTORY System in Google Sheets 📊

Practical Sheets • January 25, 2024
Video Thumbnail
Practical Sheets Logo

Practical Sheets

View Channel

About

GOOGLE SHEETS - GOOGLE FORMS - GOOGLE APPS SCRIPTS - ONLY PRACTICAL PROJECTS AND TIPS - NEW VIDEOS ON WEDNESDAYS - [email protected]

Video Description

In this video, we revamp an inventory system using Google Sheets, incorporating new functionalities and user feedback. We create a simple yet effective setup with four sheets: Products, Purchases, Sales, and Inventory. Learn how to use data validation, dropdowns, and formulas like XLOOKUP to manage your inventory efficiently. Perfect for a candy selling business or any retail operation! ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions https://practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more ➤You can also subscribe to the channel where you´ll find a new Sheets video every week. Here are some of the places where you can follow and support me: ➤Patreon: https://practicalsheets.com/patreon ➤Webpage: https://practicalsheets.com ➤Newsletter: https://practicalsheets.com/newsletter ➤Telegram: https://practicalsheets.com/telegram ➤Facebook: https://practicalsheets.com/facebook ➤Twitter: https://practicalsheets.com/twitter Any suggestion, question or insights, feel free to comment below

You May Also Like

Boost Productivity with Google Sheets

AI-recommended products based on this video

Loading...
TP-Link Tapo 3K 5MP Pan/Tilt Security WiFi Camera, Baby & Pet Camera, 360° Motion Tracking, 2-Way Audio, 40Ft. Night Vision, Cloud & Local Storage (Up to 512 GB), Works w/Alexa & Google (Tapo C230)

TP-Link Tapo 3K 5MP Pan/Tilt Security WiFi Camera, Baby & Pet Camera, 360° Motion Tracking, 2-Way Audio, 40Ft. Night Vision, Cloud & Local Storage (Up to 512 GB), Works w/Alexa & Google (Tapo C230)

(49,118)
$49.99
FREE delivery Wed, Aug 20
500+ bought in past month
Loading...
TP-Link Tapo 2K Pan/Tilt Indoor Security WiFi Camera, Baby & Pet Camera w/ 360° Motion Tracking, 2-Way Audio, Night Vision, Cloud & Local Storage (Up to 256 GB), Works w/ Alexa & Google (Tapo C210)
Amazon's Choice

TP-Link Tapo 2K Pan/Tilt Indoor Security WiFi Camera, Baby & Pet Camera w/ 360° Motion Tracking, 2-Way Audio, Night Vision, Cloud & Local Storage (Up to 256 GB), Works w/ Alexa & Google (Tapo C210)

(46,779)
32.99
FREE delivery Saturday, June 14 on your first order
2K+ bought in past month
Loading...
TP-Link Tapo 3K 5MP Pan/Tilt Security WiFi Camera, Baby & Pet Camera, 360° Motion Tracking, 2-Way Audio, 40Ft. Night Vision, Cloud & Local Storage (Up to 512 GB), Works w/Alexa & Google (Tapo C230)

TP-Link Tapo 3K 5MP Pan/Tilt Security WiFi Camera, Baby & Pet Camera, 360° Motion Tracking, 2-Way Audio, 40Ft. Night Vision, Cloud & Local Storage (Up to 512 GB), Works w/Alexa & Google (Tapo C230)

(49,118)
$49.99
FREE delivery Wed, Aug 20
500+ bought in past month
Loading...
blurams Security Camera, 2K Indoor Camera 360-degree Pet Camera for Home Security w/ Motion Tracking, Phone App, 2-Way Audio, IR Night Vision, Siren, Works with Alexa & Google Assistant,White

blurams Security Camera, 2K Indoor Camera 360-degree Pet Camera for Home Security w/ Motion Tracking, Phone App, 2-Way Audio, IR Night Vision, Siren, Works with Alexa & Google Assistant,White

(27,818)
$24.74
FREE delivery Wed, Aug 20 on your first order
500+ bought in past month
Loading...
TP-Link Tapo 2K Pan/Tilt Indoor Security WiFi Camera, Baby & Pet Camera w/ 360° Motion Tracking, 2-Way Audio, Night Vision, Cloud & Local Storage (Up to 256 GB), Works w/ Alexa & Google (Tapo C210)
Amazon's Choice

TP-Link Tapo 2K Pan/Tilt Indoor Security WiFi Camera, Baby & Pet Camera w/ 360° Motion Tracking, 2-Way Audio, Night Vision, Cloud & Local Storage (Up to 256 GB), Works w/ Alexa & Google (Tapo C210)

(46,779)
32.99
FREE delivery Saturday, June 14 on your first order
2K+ bought in past month
Loading...
(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(3,057)
$15.99
Prime
200+ bought in past month