Spreadsheets

Spreadsheets - The most powerful Data Tool

After seeing some examples of Form data collection and their associated Spreadsheets, along with some "power-tool" Add-ons for Automation, lets dig in a little more into Spreadsheets.

Spreadsheets can also be as simple as a "live" version of a paper form. Here's an example of Formatting Spreadsheets to look like a pretty 🙂 paper document example this example uses spreadsheet formatting and formula to do the work for you.

Let's Play with a simple example spreadsheet to explore some features of Spreadsheets.

Finally, let's go back and take a look at how some of the "magic" happening in the examples I showed...By exploring Add-ons

Reference Sheet for working in Spreadsheets

These are some of the Spreadsheet formulas and tools I use and can need a reminder of how they work from time to time.

Spreadsheet Tools & Formulas

Some additional new features & tools

Smart Chips - link (new @tools for use in google docs/sheets)

Smart chip Data Extraction - link

Table Templates:

Insert pre-structured tables for project management tasks

Sheets Timeline - link

Example timeline sheet - link

AI tools

Still in beta, but showing progress for quick form creation - link

Report abuse