SPREADSHEETNAME

Populates the name of the spreadsheet onto a cell. Useful when you are developing reports or dashboard templates where you can populate the name of the report directly from the name of the spreadsheet. When you change the name of the sheet, the name of the report will also get changed automatically for you.

SHEETNAME

Write the formula in any cell to populate the sheet name. Useful when you are developing reports or dashboard templates where you can populate the name of the report directly from the name of the sheet. When you change the name of the sheet, the name of the report will also get changed automatically for you.

MVLOOKUP

Extends the VLookUp formula to match with multiple columns and return a matching value. Traditional VLOOKUP can accept one column and one search value. MVLOOKUP extends the traditional VLOOKUP, It can accept multiple columns and search values and the returns value from the column that you specify at the end of the formula. In the below example the formula searches for foo from column A and boo from column B and then returns the corresponding value from column C.

_XLOOKUP

Lookup for a value in the lookup array and returns the matching value from the return array.`, desc: `Lookup for a value in the lookup array and returns the matching value from the return array. This is an equivalent to XLOOKUP provided by the new version of MS Excel. The function name starts with an \_\ as there is a conflict with  Google spreadsheet\'s native function names. Maybe Google is working is on a  function with a similar name and not yet released. In the below example value in A1 will be searched in range B:B and the corresponding value from column C will be returned. How is the different from VLOOKUP? Well, you can do reverse searches for eg:  =_XLOOKUP(A1, C:C,  B:B) which is not possible with VLOOKUP.

XSUM

Sums of the range from the cells across all the sheets in a spreadsheet. If you have many sheets in a spreadsheet and need to get the sum of the values from cell A1 in all the sheets then use this formula XSUM(A1). You can also give a range to sum eg: XSUM(A1:A10).

SUMBYCOLOR

Returns the sum of a range based on color. Give a range and a reference color, the formula returns the sum of the cells that are having the same reference color. Color should be in hex value.

RANDOMNAMES

Returns the random names of people generated by the system. Do you quickly need some dummy names to be filled in\? We got it. The formula also returns names based on the gender being passed in so that you can be accurate in what you are making.

RANDOMCOUNTRIES

Return random country names. Do you quickly need some random country names to be filled in\? We got it. You can also limit the number of country names to return.

GETTIMEZONE

Get the timezone of the given country. There is two option, either you can get ISO name of timezone for eg: 'Europe/Berlin' or GMT offset of the timezone eg: +02:00.

RANDOMSTRING

Returns a random string of characters, special characters, and numbers. Can be used to generate passwords or random id\'s. You can control the length of the string being             returned by passing in number.

EXTRACTNOTES

Extracts the notes that you have written on to a cell and return it as text. Very useful if you have a very large number of comments in sheet and need it to be read without the hassle of hovering mouse on each cell.

HASFORMULA

Finds out whether a cell has a formula in it or not. If a cell has a formula then TRUE will be returned else FALSE.

EXTRACTFORMULA

Extracts the formula that you have written on to a cell and return it as text. Very useful if you want to copy all the formulas being written in a sheet as text.

EXTRACT

Extract string, numbers, or special characters from a cell. Suppose you have mixed items in a cell, eg: $122.03 and you need to get only the number part,             well it's easy now. Possible items that can be extracted are special character only, number, and characters.

GETCELLCOLOR

Returns the background color of the cell in hex values. You can combine this formula with the SUMBYCOLOR formula and make the summation lot easier.

WORDCOUNT

Returns the count of words in a sentence. When want to know how many words are there in a sentence in the cell. Don\'t get confused with the LEN formula.            LEN formula returns the total number of characters in a sentence and not the number of words in a sentence.

LEFTWORDS

Returns a substring with the number of words starting from left. Similar to the LEFT function, but this time it returns by words and not by characters.

RIGHTWORDS

Returns a substring with the number of words starting from the right. Similar to the RIGHT function, but this time it returns by words and not by characters.

REVERSE

Reverses a range or the content of a cell. Reverses anything that you provide. If you give a cell to reverse, then its content will be reversed. If you give a range to reverse then the entire range will be reversed. Please note that when you give a range the cell content will not be reversed.

LOREMIPSUM

Returns a substring of Lorem Ipsum specified by the word count. Never be short of words, quickly fill in all the white spaces with Lorem Ipsum. You can also specify the number of words that you need. The returned string will always start with Lorem Ipsum.

AGE

Computes age from date of birth. The return value has multiple formats, such as in years, months, days, year and month, year month, and days. The default is Year-Month-Days.

TOP

Returns top-ranked items from a given list. If you have a huge list of items and need to pick the top-ranked few items then it's easy now with just one formula.

BOTTOM

Returns top-ranked items from a given list. If you have a huge list of items and need to pick the bottom-ranked few items then it's easy now with just one formula.

SHUFFLE

Shuffles the given range. Give a range of content that needs to be shuffled, the formula will return a new set of data that is totally shuffled.

ISSITEUP

Returns top-ranked items from a given list. If you have a huge list of items and need to pick the bottom-ranked few items then it's easy now with just one formula.

BOTTOM

Checks whether a website is reachable or not. If the site is up, the function will return TRUE otherwise FALSE.

NUMBERTOWORDS

Converts the given number to words. For eg: 123456789 will be one hundred and twenty-three million four hundred and fifty-six thousand seven hundred and eighty-nine.       The function can take up a really huge number, up to 10^13.

ARRAIFY

Returns the given range in an array format. Every row will be a new item group and a cell will be an item in the array.

JSONIZE

Converts the given range to the JSON object. The first row is considered as keys. Every other row will be a new item group in the JSON array.

SHUFFLE

Shuffles the given range. Select the range that you like to shuffle and click on run. The data will be shuffled and updated in the same range.

GEOCODE

Converts physical address to latitude and longitude. Select the range that you need to get geocoded and click on run. A new column will be added with latitude and longitude data.

REVERSEGEOCODE

Converts latitude and longitude to a physical address. Select the range that you need to get reverse geocoded and click on run. A new column will be added with data from Google's reverse geocode API.