In this video, author Jess Stratton shows how to use the INDIRECT and CONCATENATE formulas in Google Sheets to dynamically update a total based on a particular sheet.
- [Instructor] Let's work with Sheets for a moment.…I have here Sheet1.…This sheet contains pledge amounts.…In cell F1 on the sheet, I have a total.…The total was created by using the Sum function…of every value that's in Column C.…Down on the bottom left-hand side, it's labeled Sheet1.…I also have another sheet, Sheet2.…I can click on that sheet,…and you'll see that it's also very simple.…This sheet contains the actual donations received…from the pledges.…
Like the pledges, Cell F1 also contains…a total amount of donations,…which is also just the sum of every number…that's in Column C.…I formatted them as currency…and I did that by clicking Format,…hovering my mouse over Number, and choosing Currency.…I can create a new sheet at any time…by clicking the plus icon…in the bottom left-hand side of the screen.…It's going to add a new sheet,…and I can rename it by either clicking the down arrow…next to the sheet or right clicking.…
I'll choose Rename.…I'll call this one Totals.…I can also move this over,…by clicking and dragging with my mouse…
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.