List of formulas and parameters
| Formula | Summary | Example | Available? |
|---|---|---|---|
| AMA | |||
| GPT-3 | Given a range as a "training dataset", returns a similar pattern | GPT-3(A1:B4, "France") | Being worked on |
| Include | Returns TRUE if the string contains the substring, FALSE otherwise | INCLUDE("string", "is the word string in this sentence?) | Yes |
| Timestamp_to_date | Returns a date with the format "MM-DD-YYYY". Takes a UNIX timestamp (in seconds) as argument. | TIMESTAMPTODATE(308966400) | Yes |
| Lookup | Searches down a column for a key and returns the value of a specified cell in the row found. Cannot be nested in another function. Nor can a function be nested in a lookup | LOOKUP(#customerid, ‘Sheet2!’#id, ‘Sheet2!’#name) | Yes |
| Countuniqueifs | Counts the number of unique values in a column, filtered by a set of criteria applied to additional columns. | COUNTUNIQUEIFS(#user_name, #country, "France", #signup_date, ">"&E3) | Yes |
| Countunique | Counts the number of unique values in a column. | COUNTUNIQUE(#user_name) | Yes |
| Year | Returns the year of a specific date | YEAR("10/17/1979") | Yes |
| Month | Returns the month of a specific date, in numeric format | MONTH("10/17/1979") | Yes |
| Upper | No | ||
| Right | Returns a substring from the end of a specified string. | RIGHT("Actiondesk", 4) | No |
| Iferror | Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent. | IFERROR(A1/A2, "Error") | Being worked on |
| Left | Returns a substring from the beginning of a specified string. | LEFT("Actiondesk", 6) | No |
| Date | Converts a provided year, month, and day into a date. | DATE(1979, 10, 17) | Being worked on |
| Average | Returns the average value of a dataset | AVERAGE(#selling_price) | Yes |
| Averageifs | Returns the average of a column depending on multiple criteria. | AVERAGEIFS(#selling_price, #product_category, "phones", #country, "France") | Yes |
| Weeknum | Returns the week number | WEEKNUM("10/17/1979") | Yes |
| False | Returns the logical value FALSE | FALSE() | No |
| True | Returns the logical value TRUE | TRUE() | Yes |
| Iserror | Checks whether a value is an error. Will return TRUE or FALSE | ISERROR(10/0) | Being worked on |
| Day | Returns the day of the month of a specific date, in numeric format. | DAY("10/17/1979") | No |
| Weekday | Day of the week of the date provided (as a number) | WEEKDAY("10/17/1979") | No |
| Vlookup | No | ||
| Text | No | ||
| Search | No | ||
| Replace | No | ||
| Now | No | ||
| Lower | No | ||
| len | No | ||
| Floor | No | ||
| Ceiling | No | ||
| Days | No | ||
| Sumif | Returns the sum of a column depending on one criteria. | SUMIF(#price, #product_category, "Phones") | Yes |
| Countif | Returns the count of a column depending on one criteria. | COUNTIF(#product_category, "Phones") | Yes |
| Index | No | ||
| Datevalue | No | ||
| Datedif | No | ||
| Sumproduct | No | ||
| Islogical | No | ||
| Proper | No | ||
| Xlookup | No | ||
| Concatenate | No | ||
| Ifs | No | ||
| Percentile | No | ||
| Isnumber | No | ||
| Minifs | No | ||
| Istext | No | ||
| Match | No | ||
| Percentileif | No | ||
| Isblank | No | ||
| Rank | No | ||
| Maxifs | No | ||
| Xor | No | ||
| Round | Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. | ROUNDDOWN(99.44, 1) | Yes |
| Roundup | Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. | ROUNDUP(99.44, 1) | Yes |
| Rounddown | Rounds a number to a certain number of decimal places according to standard rules. | ROUND(99.44, 1) | Yes |
| PMT | Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. | PMT(1%, 360, 100000, 0, 0) | Yes |
| Today | Returns the current date. | TODAY() | Yes |
| Or | Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. | OR(A1=1, A2=2) | Yes |
| And | Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. | AND(A1=1, A2=2) | Yes |
| Int | Rounds a number down to the nearest integer that is less than or equal to it. | INT(24.8) | Yes |
| Not | Returns the opposite of a logical value - NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE. | NOT(TRUE) | Yes |
| If | Returns one value if a logical expression is TRUE and another if it is FALSE. | IF(42>9, “all good”, “something is wrong in the matrix”) | Yes |
| Networkdays | Returns the number of net working days between two provided dates. | NETWORKDAYS(A1, B1, C1:C10) | Yes |
| Max | Returns the maximum value in a numeric dataset. | MAX(A3, 42) | Yes |
| Min | Returns the minimum value in a numeric dataset. | MIN(A3, 5) | Yes |
| Counta | Returns the number of values in a column | COUNTA(#booking_id) | Yes |
| Sum | Returns the sum of a series of numbers and/or cells or of a column | SUM(A2:A100, 101) or SUM(#price) | Yes |
| Countifs | Returns the count of a column depending on multiple criteria. | COUNTIFS(#product_category, "Phones", #booking_date, ">"&E3) | Yes |
| Sumifs | Returns the sum of a column depending on multiple criteria. | SUMIFS(#price, #product_category, "Phones", #booking_date, ">"&E3) | Yes |