How to track income💰 in Google Sheets: Data Validation + FILTER formula
35.1 هزار بار بازدید -
6 سال پیش
-
This tutorial explains how to
This tutorial explains how to track income using Google Sheets FILTER function and data validation drop-down lists.
📈 Try coupler.io for reliable and secure data import from various apps to Google Sheets. Become an early adopter: bit.ly/youtube-coupler
💌 Contact Railsware to build your software product bit.ly/contactrailsware
🤝 Join Railsware team bit.ly/railswarecareers
🎁Download your copy of the practice sheet: bit.ly/2XnKqBe
You will learn how to build a revenue monitor and how to format Google Sheets formulas to make them readable. In this video, we will create dependent drop-down lists of regions, countries, and cities. Based on the locations selected in the monitor, we will calculate the income from filtered clients and see the list of the transactions.
This will be done with the help of FILTER, UNIQUE, and Data Validation Google Sheets functions. We will explain how to add a header of the column right in the formula and how to use IFERROR function.
You will discover the Railsware color coding approach for multiple users to collaborate on the same spreadsheet.
To boost your productivity, we’ll present several Google Sheets keyboard shortcuts, which you can add to your toolbox right away. You can then apply this data validation approach to other business-related activities and analytics.
Get your personal copy of Google Sheets practice file for this task here: bit.ly/2XnKqBe
View additional materials from Railsware and join us on social media:
🔹Twitter: bit.ly/2QgEVnR
🔸Youtube: bit.ly/2CGr3wc
🔹Facebook: bit.ly/2IoaHs4
🔸Instagram: bit.ly/2Q9Mf00
🔹LinkedIn: bit.ly/2NLWfjj
🔸Blog: bit.ly/2YWAzli
6 سال پیش
در تاریخ 1397/12/21 منتشر شده
است.
35,163
بـار بازدید شده