Google Sheets for Project Management - View the edit history...
688 views · Apr 7, 2022 bpwebs.com
This video demonstrates how to view the edit history in Google Sheets.
Google Sheets for Project Management - Add comments and assi...
411 views · Apr 7, 2022 bpwebs.com
This video demonstrates how to add comments in Google Sheets and assign them to collaborators.
How to Create Data Entry Form with Google HTML Service and S...
12K views · Apr 7, 2022 bpwebs.com
This is basically a demonstration of how to deploy your Google Apps Script as a web app. You can see the complete post at [How to Create Data Entry Form with Google HTML Service and Submit Data to Google Sheets](https://www.bpwebs.com/html-data-entry-form-to-google-sheets/)
Creating Forms in Google Sheets – Sidebar & Modal Dial...
3K views · Apr 7, 2022 bpwebs.com
This is a demo video for the post, [Creating Forms in Google Sheets Sidebar and Modal Dialog forms](https://www.bpwebs.com/creating-forms-in-google-sheets-sidebar-modal-dialog-forms) Visit the post for more details. You can make a copy of the Google Sheet in the demonstration from this [link](https://docs.google.com/spreadsheets/d/1ty8ZQbI5a7n5MF3zf8DdQ8-GFNv2WuV0BExzM7f61lU/copy)
How to Create an Online Data Entry Form that can Perform CRU...
2K views · Apr 7, 2022 bpwebs.com
This video is a demonstration video on "How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets". Visit the following blog post for the detailed guide. [How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets](https://www.bpwebs.com/how-to-create-an-online-data-entry-form-that-can-perform-crud-operations-on-google-sheets/)
How to Import Data in Google Sheets - Import Data from other...
1K views · Apr 7, 2022 bpwebs.com
The IMPORTRANGE function lets you import data from other Google spreadsheets. =IMPORTRANGE(spreadsheet_url, range_string) The first parameter of the function is the URL of the spreadsheet which contains your data to be imported. The second parameter is the range of cells that contain your data to be imported. Read more on "Import Data in Google Sheets #2 Import Data from other Spreadsheets" at https://www.bpwebs.com/import-data-in-google-sheets-2-import-data-from-other-spreadsheets/
Google Sheets Import Data - Import from multiple spreadsheet...
2K views · Apr 7, 2022 bpwebs.com
This video describes how you can import data from multiple Google Spreadsheets to a single range using the IMPORTRANGE function. Read more on How to [import data from one Google Sheet to another](https://www.bpwebs.com/import-data-from-one-google-sheet-to-another/)
Google Sheets Checkbox - Apply Conditional Formatting across...
6K views · Apr 7, 2022 bpwebs.com
You can use the checkbox to make Google Sheets more interactive. In this video, I will show you how you can apply conditional formatting across the entire row of your data table once you click a checkbox. You may read more about, [How to use Google Sheets Checkbox – [6 Examples]](https://www.bpwebs.com/how-to-use-google-sheets-checkbox)
How to pull data from Google Sheets to HTML table
12K views · Apr 7, 2022 bpwebs.com
This video is a demonstration video on "How to pull data from Google Sheets to HTML table". Visit the following link to see the complete blog post. [How to pull data from Google Sheets to HTML table](https://www.bpwebs.com/pull-data-from-google-sheets-to-html-table/) Post Summary With Google Apps Script, Bootstrap and, DataTables jQuery Plugin you can build beautiful HTML tables to show your Google Sheets Data. The DataTables plugin lets you add search, sort, and filter functions to the HTML table. Using Bootstrap you can add styles to your table. This way you can show your data to others without giving access to your Google Sheet.
Highlight multiple rows of Google Sheets based on conditions...
5K views · Apr 7, 2022 bpwebs.com
You can use Google Sheets conditional formatting to highlight multiple rows based on given conditions. You can also attach a checkbox to these conditions so that the rows are highlighted based on the state of the check box (checked or unchecked). You may also read, [How to use Google Sheets Checkbox – 6 Examples](https://www.bpwebs.com/how-to-use-google-sheets-checkbox)
Google Sheets for Project Management - Template Gallery
4K views · Apr 7, 2022 bpwebs.com
How to use Google Sheets for Project Management You can read the complete article at https://www.bpwebs.com/how-to-use-google-sheets-for-project-management/
Google Sheets for Project Management - Add Task Description
876 views · Apr 7, 2022 bpwebs.com
How to use Google Sheets for Project Management You can read the complete article at https://www.bpwebs.com/how-to-use-google-sheets-for-project-management/
Google Sheets for Project Management - Create Drop-down List...
2K views · Apr 7, 2022 bpwebs.com
How to use Google Sheets for Project Management You can read the complete article at https://www.bpwebs.com/how-to-use-google-sheets-for-project-management/
Google Sheets for Project Management - Receive Email Notific...
1K views · Apr 7, 2022 bpwebs.com
How to use Google Sheets for Project Management You can read the complete article at https://www.bpwebs.com/how-to-use-google-sheets-for-project-management/
Google Sheets for Project Management - Lock critical content
2K views · Apr 7, 2022 bpwebs.com
How to use Google Sheets for Project Management You can read the complete article at https://www.bpwebs.com/how-to-use-google-sheets-for-project-management/
How to import data from websites to Google Sheets
1K views · Oct 20, 2022 bpwebs.com
How to import data from websites to Google Sheets
Count duplicates using Google Sheets Query function
2K views · Oct 31, 2022 bpwebs.com
Count duplicates using the Google Sheets Query function
Highlight duplicate rows in Google Sheetsts
643 views · Nov 1, 2022 bpwebs.com
Highlight duplicate rows in Google Sheets
Highlight duplicates in Google Sheets multiple columns
823 views · Nov 1, 2022 bpwebs.com
Highlight duplicates in Google Sheets multiple columns
Identify duplicates with Google Sheets Data Cleanup Suggesti...
2K views · Nov 1, 2022 bpwebs.com
Identify duplicates with Google Sheets Data Cleanup Suggestions
How to create crypto news feed in Google Sheets
217 views · Dec 16, 2022 bpwebs.com
In this video, we discussed how to create your own crypto news feed in Google Sheets. Further, we automated this Google Sheets to email the newsfeed to the inbox daily. And this is not limited to crypto news, you can use this method to create your own news feed on any subject you prefer. You can read the complete blog post at; https://www.bpwebs.com/how-to-create-a-crypto-news-feed-in-google-sheets/
How to generate static Google Maps in Google Sheets - Add pa...
729 views · Mar 9, 2023 bpwebs.com
This video is about creating Google Maps in Google Sheets. In our previous videos, we discussed how to add place markers and add distinct colors and labels to markers based on categories. You can see those videos from following links. https://www.bpwebs.com/humix/video/37c0630ad827ef8244897c6c7be5801673a7c71e https://www.bpwebs.com/humix/video/e291ee37a91352d79076131d0782bdfc4f051557 In this video, I will show you how to map paths between origin and destination points via waypoints. You can read the entire blog post at: https://www.bpwebs.com/how-to-generate-static-google-maps-in-google-sheets/ You can copy the Google Sheets in the video from the following link. https://docs.google.com/spreadsheets/d/1BWNk59IQjhZYppVk2zJVlcuP3WUknSA7WAN_K3FUdCw/copy
Create Static Google Map of place markers in Google Sheets
3K views · Mar 9, 2023 bpwebs.com
With the Google Apps Script’s StaticMap class, we can create custom Google Maps images. In this video, I will show you how to add place markers to a Google Map and create a static Google Map in Google Sheets.
How to generate static Google Maps in Google Sheets - Add di...
16K views · Mar 9, 2023 bpwebs.com
This video is about creating Google Maps in Google Sheets. This will show you how to add place markers for a set of geographic coordinates stored in Google Sheets. It will also show you how to add distinct colors and labels to place markers based on place categories in another column of your data table. You can read the complete blog post at: https://www.bpwebs.com/how-to-generate-static-google-maps-in-google-sheets/
Periodically Extract Website Data to Google Sheets
4K views · Apr 5, 2023 bpwebs.com
Nowadays, we have access to an abundance of data that can aid us in decision-making. Website data is a particularly accessible and cost-effective source, provided that we utilize appropriate data collection techniques and tools. Google Sheets is one such tool that can be used for free. In this video, I will demonstrate how you can periodically extract website data to Google Sheets. By utilizing this method, you can streamline the process of gathering live data from websites and storing it directly into Google Sheets. By doing so, you will have the ability to access historical data for use in your data analysis projects. This automated approach can save time and effort, as you no longer need to manually collect data from various sources. Instead, the data will be continuously updated and readily available for your analysis needs. Visit the following link to read the complete blog post and to copy the Google Sheets with the Apps Script. https://www.bpwebs.com/periodically-extract-website-data-to-google-sheets/ You can learn more about Importing data from websites to Google Sheets from the following link. https://www.bpwebs.com/how-to-import-data-from-website-to-google-sheets/
How to Create an Online Data Entry Form that can Perform CRU...
4K views · Apr 20, 2023 bpwebs.com
This is a demo video of a web app created with Google Sheets and Google Apps Script. Go the following blog post to learn how to create this type of web app for free. "How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets" at https://www.bpwebs.com/crud-operations-on-google-sheets-with-online-forms/
How to Create an Online Data Entry Form that can Perform CRU...
52K views · May 7, 2023 bpwebs.com
Watch on YouTube for high quality video: https://youtu.be/aQlUbQQP8IM This video is a demonstration video on "How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets". Visit the following link to see the complete blog post at bpwebs.com. https://www.bpwebs.com/crud-operations-on-google-sheets-with-online-forms/ Post Summary Learn how Google Apps Scripts can supercharge your favorite Google apps. With Google Apps Script, you can create customized solutions to boost collaboration and productivity. In this tutorial, I'll show you how to build an Online Data Entry Form that can add, edit, delete, and retrieve data from Google Sheets. By using Google Sheets APIs and Google Apps Script's HTML service, you'll discover how to create interactive forms for your everyday tasks. I've included all the necessary form elements you'll need to create various types of forms without requiring extensive coding knowledge. Even if you're not a coding expert, you can easily customize this form to meet your specific needs. Simplify your data entry process and save time with just a few simple steps.
How to Create an Online Data Entry Form that can Perform CRU...
4K views · Apr 20, 2023 bpwebs.com
This is a demo video of a web app created with Google Sheets and Google Apps Script. Go the following blog post to learn how to create this type of web app for free. "How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets" at https://www.bpwebs.com/crud-operations-on-google-sheets-with-online-forms/
Periodically Extract Website Data to Google Sheets
4K views · Apr 5, 2023 bpwebs.com
Nowadays, we have access to an abundance of data that can aid us in decision-making. Website data is a particularly accessible and cost-effective source, provided that we utilize appropriate data collection techniques and tools. Google Sheets is one such tool that can be used for free. In this video, I will demonstrate how you can periodically extract website data to Google Sheets. By utilizing this method, you can streamline the process of gathering live data from websites and storing it directly into Google Sheets. By doing so, you will have the ability to access historical data for use in your data analysis projects. This automated approach can save time and effort, as you no longer need to manually collect data from various sources. Instead, the data will be continuously updated and readily available for your analysis needs. Visit the following link to read the complete blog post and to copy the Google Sheets with the Apps Script. https://www.bpwebs.com/periodically-extract-website-data-to-google-sheets/ You can learn more about Importing data from websites to Google Sheets from the following link. https://www.bpwebs.com/how-to-import-data-from-website-to-google-sheets/
Create Your Own Personal Finance Tracker App with Google She...
4K views · Jul 15, 2023 bpwebs.com
Blog post link: https://www.bpwebs.com/personal-finance-tracker-app-with-google-sheets/ Keeping track of your income and expenditures is an important part of your financial planning. It can help you understand your spending habits, set financial goals, make informed financial decisions, and spot potential problems early on. There are many different ways to store your income and expenses. Some people use a paper budget, while others use a budgeting app or software as their personal finance tracker. There are plenty of financial tracking apps and templates available out there. However, you will have several advantages in using Google Sheets as your income and expense tracker. In this video, I explain how you can customize and use the Google Sheet I have created for tracking personal income and expenses. This Google Sheet contains a sidebar form and web app to easily add your income and expenditure entries. The responsive layout of the web app lets you easily use it on your smartphone on the go.
How to create progress bars in Google Sheets
4K views · Sep 21, 2023 bpwebs.com
A progress bar is a graphical representation used to visually indicate the status or progress of a task, process, or operation. Google Sheets is a very useful tool to measure progress because it is free, and you can easily share it with your team members and work on multiple device types. In this video, I will show you how you can create progress bars in Google Sheets to visualize your progress.
How to Create a Weather Dashboard in Google Sheets
3K views · Jan 7, 2024 bpwebs.com
Read the complete blog post at: https://www.bpwebs.com/how-to-create-a-weather-dashboard-in-google-sheets/ Have you ever wanted to track local weather conditions without leaving your favorite spreadsheet tool? Or do you need to keep track of the weather in different locations without constantly checking multiple websites? With a little bit of code, you can create a dynamic weather dashboard that pulls in data from the OpenWeatherMap API and displays it clearly and concisely in Google Sheets. In this video, I will show you how to set up a simple weather dashboard in Google Sheets using the OpenWeatherMap API. Read the following blog post for more information and to get a copy of the Google Sheet and the code described in the video. https://www.bpwebs.com/how-to-create-a-weather-dashboard-in-google-sheets/