# 🧙🏻‍♂️Online automation. Google Sheets & Scripts

This site was created by Max Makhrov, a Google Innovator champion and Google Sheets enthusiast with over 17 years of experience. Max has honed his skills to become a professional developer.

You can hire him for custom projects, including Add-Ons, Reports, API integrations, SQL-based accounting systems, or anything involving Apps Script and Google Workspace.

Max enjoys sharing his insights on Twitter and Medium. Below are some useful tips for you ↓

Convert range 2 image in Sheets.

## 💡Collection of Formulas

Collection of 80+ named functions for any case :)

Collection

🏅Collections

🟢Formulas

## Number Format

See decimal points for the small numbers in the report.

Tweet

🟡Tips & Tricks

## 💚The Love Formula

This is a sample formula + conditional formatting for creating shapes in a Spreadsheet grid.

🏅Collections

🟢Formulas

🟠Challenges

🟢Formulas

## Undocumented Function

Use "CONDITION_ONE_OF_RANGE" hidden function to filter the range by multiple matches from a list.

Tweet

🟡Tips & Tricks

🟢Formulas

## Benchmark

BENCHMARK named function to test the speed of your formulas.

Tweet

🟡Tips & Tricks

🟢Formulas

## Gantt

🐇Gantt Chart ArrayFormula

🟢Formulas

## 📋 Fill_Down

Named function Sheets. It fills down values if blank from the top filled cells in each column.

🟢Formulas

## CrossJoin

Named function Sheets gives all possible combinations of 2 lists. With the new BYROW function this formula should work much faster.

🟢Formulas

## ByRow Tricks

It's breaking the rules!

BYROW + LAMBDA in Google Sheets can convert any function into Array Formula.

Tweet

🟡Tips & Tricks

🟢Formulas

## Combine Ranges

Put 1 range above another with this elegant formula.

Tweet

🟡Tips & Tricks

🟢Formulas

=QUERY({A4:C};"where Col1 matches 'West|East'")

'West'

OR

'East'

🟡Tips & Tricks

🟢Formulas

## TYPE function

TYPE function in #GoogleSheets helped me to figure out why 2 of my cells are not equal.

🟡Tips & Tricks

🟢Formulas

## Bar-Code with a formula

Challenge — create your own Bar Code Formula using the SparkLine function.

🟠Challenges

🟢Formulas

# Want more content like this?

## ⛓️Dependent Drop-Downs

Dependent drop-down lists can be used to create a dynamic list of choices in Google Sheets.

# ➡️Apps Script Tools

## 😽GitHub

It has 200+⭐stars, but it's still messy. One day I'd like to take care of the beautiful description and better structure of the files later.

Any ideas are welcome!

## 💌MmailApp

Library lets you send emails, using

The library takes care of parameters, so you do not need to care about which method to use.

## 🖨️Sheet2PDF

Library for converting Google Sheets™ Into PDF.

Featurs:

⚙️ All PDF settings including colontitles = custom headers and footers.

🔌Input parameters is a single plain object.

## 🧬Jsonata gs

Jsonatags is a library that enables the use of the Jsonata.js

It helps you to manipulate jsons with a query-like language.