List of formulas and parameters
| Formula | Summary | Example | Available? | New Engine Status |
|---|---|---|---|---|
| Include | Returns TRUE if the string contains the substring, FALSE otherwise | INCLUDE("string", "is the word string in this sentence?) | Yes | To implement |
| Timestamp_to_date | Returns a date with the format "MM-DD-YYYY". Takes a UNIX timestamp (in seconds) as argument. | TIMESTAMPTODATE(308966400) | Yes | To implement |
| Year | Returns the year of a specific date | YEAR("10/17/1979") | Yes | To implement |
| Month | Returns the month of a specific date, in numeric format | MONTH("10/17/1979") | Yes | To implement |
| Weeknum | Returns the week number | WEEKNUM("10/17/1979") | Yes | To implement |
| Average | Returns the average value of a dataset | AVERAGE(#selling_price) | Yes | To implement |
| Round | Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. | ROUNDDOWN(99.44, 1) | Yes | To implement |
| Roundup | Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. | ROUNDUP(99.44, 1) | Yes | To implement |
| Rounddown | Rounds a number to a certain number of decimal places according to standard rules. | ROUND(99.44, 1) | Yes | To implement |
| 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 | To implement |
| Not | Returns the opposite of a logical value - NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE. | NOT(TRUE) | Yes | To implement |
| Int | Rounds a number down to the nearest integer that is less than or equal to it. | INT(24.8) | Yes | To implement |
| 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 | To implement |
| 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 | To implement |
| 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 | To implement |
| Min | Returns the minimum value in a numeric dataset. | MIN(A3, 5) | Yes | To implement |
| Max | Returns the maximum value in a numeric dataset. | MAX(A3, 42) | Yes | To implement |
| Networkdays | Returns the number of net working days between two provided dates. | NETWORKDAYS(A1, B1, C1:C10) | Yes | To implement |
| Upper | Return the string in uppercase | UPPER("Actiondesk") | No | To implement |
| Right | Returns a substring from the end of a specified string. | RIGHT("Actiondesk", 4) | No | To implement |
| Proper | The PROPER function sets the first character in each word to uppercase and the rest to lowercase | No | To implement | |
| Isnumber | Returns true if value is a number. It must be true if it is a string representing a number. | No | To implement | |
| Istext | Return true if value is a string | No | To implement | |
| Isblank | Return true if empty string | No | To implement | |
| Rank | The RANK function returns the rank of a number in a list of numbers. | No | To implement | |
| Xor | No | To implement | ||
| Ifs | No | To implement | ||
| Concatenate | No | To implement | ||
| Islogical | No | To implement | ||
| Datevalue | No | To implement | ||
| Index | No | To implement | ||
| Floor | No | To implement | ||
| len | No | To implement | ||
| Lower | No | To implement | ||
| Replace | No | To implement | ||
| Search | No | To implement | ||
| Text | No | To implement | ||
| Weekday | Day of the week of the date provided (as a number) | WEEKDAY("10/17/1979") | No | To implement |
| Day | Returns the day of the month of a specific date, in numeric format. | DAY("10/17/1979") | No | To implement |
| Left | Returns a substring from the beginning of a specified string. | LEFT("Actiondesk", 6) | No | To implement |
| 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 | To implement |
| Iserror | Checks whether a value is an error. Will return TRUE or FALSE | ISERROR(10/0) | Being worked on | To implement |
| Date | Converts a provided year, month, and day into a date. | DATE(1979, 10, 17) | Being worked on | To implement |
| Match | No | To be specified | ||
| Percentile | No | To be specified | ||
| Sumproduct | No | To be specified | ||
| Datedif | No | To be specified | ||
| Days | No | To be specified | ||
| Ceiling | No | To be specified | ||
| True | Returns the logical value TRUE | TRUE() | Yes | Done |
| False | Returns the logical value FALSE | FALSE() | Yes | Done |
| Today | Returns the current date. | TODAY() | Yes | Done |
| Sum | Returns the sum of a series of numbers and/or cells or of a column | SUM(A2:A100, 101) or SUM(#price) | Yes | Done |
| Now | No | Done | ||
| 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 | To not implement |
| 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 | To not implement |
| Countunique | Counts the number of unique values in a column. | COUNTUNIQUE(#user_name) | Yes | To not implement |
| Countif | Returns the count of a column depending on one criteria. | COUNTIF(#product_category, "Phones") | Yes | To not implement |
| Sumif | Returns the sum of a column depending on one criteria. | SUMIF(#price, #product_category, "Phones") | Yes | To not implement |
| Averageifs | Returns the average of a column depending on multiple criteria. | AVERAGEIFS(#selling_price, #product_category, "phones", #country, "France") | Yes | To not implement |
| Counta | Returns the number of values in a column | COUNTA(#booking_id) | Yes | To not implement |
| Sumifs | Returns the sum of a column depending on multiple criteria. | SUMIFS(#price, #product_category, "Phones", #booking_date, ">"&E3) | Yes | To not implement |
| Countifs | Returns the count of a column depending on multiple criteria. | COUNTIFS(#product_category, "Phones", #booking_date, ">"&E3) | Yes | To not implement |
| Maxifs | No | To not implement | ||
| Percentileif | No | To not implement | ||
| Minifs | No | To not implement | ||
| Xlookup | No | To not implement | ||
| Vlookup | No | To not implement | ||
| GPT-3 | Given a range as a "training dataset", returns a similar pattern | GPT-3(A1:B4, "France") | Being worked on | To not implement |
| AMA | To not implement | |||