How To 10x Your LiveFlow Experience

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Google Sheets Tips

Conditional Formatting in Google Sheets: Explained

Learn how to use Conditional Formatting function in Google Sheets

Google Sheets Tips

How to Highlight Duplicates in Google Sheets

Learn how to highlight duplicates with Conditional Formatting in Google Sheets

Google Sheets Tips

How to Use Wildcard Characters in Google Sheets

Learn what wildcard characters are and how to use them in Google Sheets

Google Sheets Tips

How to Insert Multiple Rows in Google Sheets

Learn how to insert multiple rows in Google Sheets quickly

Google Sheets Tips

How to Insert Multiple Columns in Google Sheets

Learn how to insert multiple columns in Google Sheets quickly

Google Sheets Formulas

How to Use MAP Function in Google Sheets

Learn what is the MAP formula and how to use it quickly

Google Sheets Formulas

How to Use MAKEARRAY Formula in Google Sheets

Learn what the MAKEARRAY function and how to use it quickly

Google Sheets Formulas

How to Use SCAN Function in Google Sheets

Learn what the SCAN formula is and how to use it quickly

Google Sheets Formulas

How to Use REDUCE Function in Google Sheets

Learn what the REDUCE formula and how to use it quickly

Google Sheets Formulas

How to Use BYCOL Function in Google Sheets

Learn what the BYCOL formula is and how to use it in Google Sheets

Google Sheets Formulas

How to Use BYROW Function in Google Sheets

Learn what the BYROW formula is and how to use it in Google Sheets

Google Sheets Formulas

How to Use POWER Function in Google Sheets

Learn how to use the POWER formula in Google Sheets

Google Sheets Tips

Conditional Formatting Based on Another Cell Value in Google Sheets: Explained

Learn how to use Conditional Formatting based on a value in another cell

Google Sheets Formulas

How to Trim Whitespaces in Google Sheets

Learn how to remove extra spaces in Google Sheets

Google Sheets Formulas

How to Use RANK Function in Google Sheets

Learn how to use the RANK formula in Google Sheets

Google Sheets Formulas

How to Use INDEX Function in Google Sheets

Learn how to use the INDEX function quickly

Google Sheets Formulas

How to Use MATCH Function in Google Sheets

Learn how to use the MATCH formula in Google Sheets

Google Sheets Formulas

EOMONTH Function in Google Sheets: Explained

Learn how to use the EOMONTH formula in Google Sheets

Google Sheets Formulas

How to Use TRANSPOSE Function in Google Sheets

Learn how to use the TRANSPOSE formula in Google Sheets

Google Sheets Tips

How to Make a Waterfall Chart in Google Sheets

Learn how to create a waterfall chart in Google Sheets

Google Sheets Tips

How to Add a Comment to a Cell in Google Sheets

Learn how to insert a comment in Google Sheets

Google Sheets Tips

How to Insert a Note in Google Sheets

Learn how to add a note to a cell in Google Sheets

Google Sheets Tips

How to Indent Texts in Google Sheets: Explained

Learn how to add indentation to texts in Google Sheets

Google Sheets Tips

How to Alternate Row Colors in Google Sheets

Learn how to color rows alternately in Google Sheets

Google Sheets Tips

How to Merge Cells in Google Sheets

Learn how to merge cells in Google Sheets quickly

Google Sheets Tips

How to Tag Someone in Google Sheets

Learn how to tag and assign someone in Google Sheets

Google Sheets Tips

How to Calculate Compound Annual Growth Rate (“CAGR”) in Google Sheets

Learn about Compound Annual Growth Rate and how to compute it in Google Sheets

Google Sheets Formulas

AVERAGEIF Function in Google Sheets: Explained

Learn how to use the AVERAGEIF formula in Google Sheets

Google Sheets Formulas

How to Use the CONCATENATE function in Google Sheets

Learn how to use the CONCATENATE formula in Google Sheets

Google Sheets Formulas

How to Insert Current Time with NOW Function in Google Sheets

Learn how to use the NOW formula in Google Sheets

Google Sheets Tips

Comment History in Google Sheets: Explained

Learn how to view the Comment History in Google Sheets

Google Sheets Formulas

AVERAGEIFS Function in Google Sheets: Explained

Learn how to use the AVERAGEIFS formula in Google Sheets

Google Sheets Formulas

How to Use EDATE Function in Google Sheets

Learn how to use the EDATE formula in Google Sheets quickly

Google Sheets Formulas

FILTER Function in Google Sheets: Explained

Learn how to use the FILTER function in Google Sheets

Google Sheets Formulas

How to Use CHOOSE Function in Google Sheets

Learn how to use the CHOOSE formula in Google Sheets quickly

Google Sheets Formulas

Named Range in Google Sheets: Explained

Learn Named Range and how to use it in Google Sheets

Google Sheets Tips

How to Resize Column Width in Google Sheets

Learn how to change columns' widths in Google Sheets quickly

Google Sheets Tips

How to Change Default Font in Google Sheets

Learn how to change the default font setting in Google Sheets

Google Sheets Tips

Relative Reference and Absolute Reference in Google Sheets: Explained

Learn the difference between relative reference and absolute reference in Google Sheets

Google Sheets Tips

How to Resize Row Height in Google Sheets

Learn how to change row height in Google Sheets quickly

Google Sheets Tips

How to Wrap Text in Cell in Google Sheets

Learn three text formatting, wrap, overflow, and clip, and make your table more beautiful

Google Sheets Formulas

How to Use SWITCH Function in Google Sheets

Learn how to use the SWITCH formula in Google Sheets quickly

Google Sheets Tips

Switch Rows and Columns in Google Sheets: Explained

Learn how to switch rows and columns by Spacial Paste in Google Sheets

Google Sheets Tips

How to Switch Two Columns and Rows in Google Sheets

Learn how to swap two columns in Google Sheets quickly

Google Sheets Formulas

How to Use REPLACE Function in Google Sheets

Learn how to use the REPLACE formula in Google Sheets

Google Sheets Formulas

How to Use IMPORTRANGE Function in Google Sheets

Learn how to use the IMPORTRANGE formula in Google Sheets

Google Sheets Tips

How to Set Print Area in Google Sheets

Learn how to print out Google Sheets properly

Google Sheets Tips

How to Find and Replace Words in Google Sheets

Learn how to utilize Find and Replace in Google Sheets

Google Sheets Tips

Autofill Function in Google Sheets: Explained

Learn how to utilize Autofill function in Google Sheets

Google Sheets Formulas

UNIQUE Function in Google Sheets: Explained

Learn how to use UNIQUE function to remove duplicates in Google Sheets

Google Sheets Tips

How to Split Texts into Columns in Google Sheets

Learn how to split texts horizontally in Google Sheets

Google Sheets Formulas

TEXT Function in Google Sheets: Explained

Learn how to change text formatting with the TEXT function in Google Sheets

Google Sheets Formulas

How to Use SPLIT Function in Google Sheets

Learn how to split texts with the SPLIT function in Google Sheets

Google Sheets Tips

How to Remove Duplicates in Google Sheets

Learn how to eliminate duplicates in a data set in Google Sheets

Google Sheets Tips

Filter in Google Sheets: Explained

Learn how to use a filter in Google Sheets

Google Sheets Tips

Filter Views in Google Sheets: Explained

Learn Filter Views and how to use in Google Sheets quickly

Google Sheets Formulas

COUNTUNIQUE Function in Google Sheets: Explained

Learn the COUNTUNIQUE formula and how to use it in Google Sheets

Google Sheets Formulas

COUNTBLANK Function in Google Sheets: Explained

Learn the COUNTBLANK function and how to use it in Google Sheets

Google Sheets Formulas

COUNT Function in Google Sheets: Explained

Learn how to use the COUNT function in Google Sheets quickly

Google Sheets Formulas

COUNTA Function in Google Sheets: Explained

Learn how to use the COUNTA function in Google Sheets

Google Sheets Formulas

ARRAYFORMULA Function in Google Sheets: Explained

Learn the ARRAYFORMULA and how to use it in Google Sheets

Google Sheets Formulas

AND Function in Google Sheets: Explained

Learn the AND function and how to use it in Google Sheets

Google Sheets Formulas

INDIRECT Function in Google Sheets: Explained

Learn the INDIRECT function and how to use it in Google Sheets

Google Sheets Tips

How to Add a Check Box in Google Sheets

Learn how to add a checkbox and make your Google Sheets more effective

Google Sheets Tips

Dependent Drop-down List in Google Sheets: Explained

Learn how to create a dependent drop-down menu in Google Sheets

Google Sheets Formulas

OR Function in Google Sheets: Explained

Learn the OR function and how to use it in Google Sheets

Google Sheets Formulas

DATEVALUE Function in Google Sheets: Explained

Learn how to use the DATEVALUE formula in Google Sheets

Google Sheets Tips

Pivot Table in Google Sheets: Explained

Learn Pivot Table and how to use it in Google Sheets

Google Sheets Tips

How to Align Text in Google Sheets

Learn how to align text vertically and horizontally in Google Sheets

Google Sheets Tips

How to Make a Line Chart in Google Sheets

Learn how to create a line chart in Google Sheets quickly

Reports

Import large amounts of QuickBooks transactions to G-Sheets with Live Functions

This guide covers how you can import tens of thousands of transactions from QuickBooks into G-Sheets

Google Sheets Formulas

COLUMN Function in Google Sheets: Explained

Learn how to use the COLUMN function in Google Sheets quickly

Google Sheets Formulas

ROW Function in Google Sheets: Explained

Learn how to use the ROW function in Google Sheets

Google Sheets Formulas

MOD Function in Google Sheets: Explained

Learn how to use the MOD function in Google Sheets

Google Sheets Tips

Alternate Column Colors in Google Sheets: Explained

Learn how to alternate column colors by Conditional Formatting in Google Sheets

Google Sheets Tips

How to Make a Bubble Chart in Google Sheets

Learn how to create a bubble chart in Google Sheets

Google Sheets Tips

How to Make a Stacked Column Chart in Google Sheets

Learn how to create a stacked column chart in google sheets

Google Sheets Formulas

OFFSET Function in Google Sheets: Explained

Learn what the OFFSET function is and how to use it in Google Sheets

Google Sheets Tips

What is Google Data Studio?

Learn what Google Data Studio is and how you can make it live with LiveFlow

Integrations

Is It Possible to Integrate a Form to an Existing Google Sheets?

You need to open the form in Google Forms, click Responses, then click the spreadsheet icon.

Support

How to Translate Google Sheets to Desired Language

Open the Google Sheet you want to translate, and then go to the Tools menu.

Support

How to Search in Google Sheets

Here’s what you need to know about how to search in Google Sheets.‍

Reports

How to copy a Google Sheet into an existing Google Sheet

The good news it's super easy and will take you a couple of seconds!

Settings

How To Open Your Workspace

Google Sheets Formulas

SEARCH Function in Google Sheets: Explained

Learn how to use the SEARCH formula in Google Sheets quickly

Google Sheets Formulas

FIND Function in Google Sheets: Explained

Learn how to use the FIND formula in Google Sheets quickly

Google Sheets Formulas

GOOGLEFINANCE Function in Google Sheets: Explained

Learn how to quote stock information and currency date with the GOOGLEFINANCE funtion

Google Sheets Formulas

YEAR Function in Google Sheets: Explained

Learn how to extract the year from a date quickly by using the YEAR function in Google Sheets

Google Sheets Formulas

MONTH Function in Google Sheets: Explained

Learn how to pull out the month from a date quickly by using the MONTH function in Google Sheets

Google Sheets Formulas

DAY Function in Google Sheets: Explained

Learn how to extract the day from a date quickly by using the DAY function in Google Sheets

Google Sheets Formulas

WORKDAY Function in Google Sheets: Explained

Learn how to get an ending date based on a starting date and the number of days you have.

Google Sheets Formulas

NETWORKDAYS Function in Google Sheets: Explained

Learn how to compute the number of working days excluding holidays.

Google Sheets Formulas

DAYS Function in Google Sheets: Explained

Learn how to use the DAY formula in Google Sheets quickly

Google Sheets Formulas

LEN Function in Google Sheets: Explained

Learn how to use the LEN function in Google Sheets quickly

Google Sheets Formulas

CHAR Function in Google Sheets: Explained

Learn how to use the CHAR formula in Google Sheets quickly

Google Sheets Formulas

REPT Function in Google Sheets: Explained

Learn how to use the REPT formula in Google Sheets quickly

Reports

My report is too large to import

Solution: Try a shorter date range, add filters or try our Live Functions.

Google Sheets Tips

Google Sheets Sign-in: Explained

Learn how to sign in to Google Sheets quickly

Google Sheets Tips

How to Reference Another Sheet in Google Sheets

Learn how to reference data on another sheet in formulas quickly

Google Sheets Tips

How to Make a Table in Google Sheets

Learn how to insert a table in Google Sheets quickly

Sorry! We couldn't find any results for that yet.

Know a vendor we should add to our partner directory? Email us at founders@liveflow.io

How can we help you today?

Get personal help

Getting started

Category

Sorry! We couldn't find any results for that yet.