Functions
GoAutomate includes a variety of functions similar to those in Microsoft Excel. While most functions will be familiar, some may have slight differences. Additionally, GoAutomate offers unique functions for handling Text using advanced regular expression patterns. Please review the details below.
All Functions (alphabetical)
| Function | Description |
|---|---|
| ABS | Returns the absolute value of a number |
| AND | Returns TRUE if all logical conditions are TRUE |
| APPEND | Adds the items from the second array to the end of the first array |
| ASSERT | Generate a specific validation error message if the logical condition evaluates to FALSE |
| BEGINS | Checks to see the first text value begins with the second text value |
| CLEAN | Removes all non-printable characters from the text |
| CONCAT | Joins several text items into one text item |
| COUNT | Counts how many numbers are in the array |
| COUNTA | Counts the non-blank items in array |
| COUNTALL | Count all items in the array, including blank items |
| COUNTBLANK | Counts only blank items in an array |
| COUNTIF | Counts the number of items in the array that meet the given criteria |
| COUNTMATCH | Counts the number of items in the array that match the regular expression pattern |
| CREATE | Creates an array using the values provided |
| DATE | Create a date from the year, month and day |
| DATEVALUE | Create a date from the text value |
| DAY | Return the day of the month from a date as an integer between 1 and 31 |
| DAYS | Returns the number of days between two dates |
| DECIMALS | Returns the number of decimal places in the given number |
| DELETE | Delete the item in the array at the specified position |
| EDATE | Returns the date adjusted by the number of months before or after the start date |
| ENDS | Checks to see the first text value ends with the second text value |
| EPOCH | Returns the number of milliseconds since 1 January 1970 as a number |
| EXACT | Checks to see if two text or choice values are identical (case-sensitive) |
| FALSE | Returns the logical value FALSE |
| FILL | Create an array with the specified number of items, each filled with the given value |
| FIND | Finds the position of one text value within another (case-sensitive) |
| FIRST | Returns the first item from an array |
| HOUR | Returns the hour of a time or date/time value |
| IF | Returns the first value if the logical condition is TRUE otherwise return the second value |
| IFS | Checks whether one or more logical conditions are TRUE and returns a value that corresponds to the first TRUE condition |
| INDEX | Returns an item from an array at the position given |
| INSERT | Insert an item into an array at the position given |
| INT | Rounds a number down to the nearest whole number |
| ISBLANK | Returns TRUE if the value is blank |
| ISDATE | Returns TRUE if the value is a date |
| ISEVEN | Returns TRUE if the number is even |
| ISNUMBER | Returns TRUE if the value is a number |
| ISODD | Returns TRUE if the number is odd |
| ISTEXT | Returns TRUE if the value is text |
| ISTIME | Returns TRUE if the value is a time |
| LAST | Returns the last item from an array |
| LEFT | Returns the leftmost characters from a text value |
| LEFTPAD | Left pad the text with the given character a number of times |
| LEN | Returns the number of characters in a text value |
| LOWER | Converts text to lowercase |
| MATCH | Searches for a specified value in an array and returns the relative position of that value |
| MID | Returns a specific number of characters from a text value starting at the given position |
| MINUTE | Returns the minute of a time or date/time value |
| MOD | Returns the remainder after division |
| MONTH | Returns the month of a date or date/time value |
| NETWORKDAYS | Returns the number of whole workdays between two dates |
| NOT | Reverses a logical value |
| NOTBLANK | Returns TRUE if a value is present |
| NOW | Returns the current date and time |
| OR | Returns TRUE if any logical condition is TRUE |
| PROPER | Capitalizes the first letter in each word in the text |
| RAND | Returns a random number between 0 and 1 |
| REGEX_MATCH | Check if text matches the specified regular expression pattern |
| REGEX_REPLACE | Replaces characters within the text matching the specified regular expression pattern with new text |
| REGEX_SEARCH | Finds a matching regular expression pattern within a text value and returns the relative position of that match |
| REPLACE | Replaces matching parts of text with a replacement text value |
| REPT | Repeats text a given number of times |
| RIGHT | Returns the rightmost characters from a text value |
| ROUND | Rounds a number to a specified number of digits |
| SEARCH | Finds the position of one text value within another (case-insensitive) |
| SECOND | Returns the seconds of a time or date/time value |
| SUBSTITUTE | Substitutes new text for old text in a text value |
| SUM | Sum together value of all array items |
| TEXT | Formats a value and converts it to text |
| TIME | Create a time from the hour, minute and second |
| TIMEVALUE | Create a time from the text value |
| TODAY | Returns the current date |
| TRIM | Removes spaces from text |
| TRUE | Returns the logical value TRUE |
| UPPER | Converts text to uppercase |
| VALUE | Convert text to a number |
| WEEKDAY | Returns the day of the week of a date or date/time ranging from 1 (Sunday) to 7 (Saturday) |
| YEAR | Returns the year of a date or date/time value |
Text functions
Functions for handling Text values.
| Function | Description |
|---|---|
| BEGINS | Checks to see the first text value begins with the second text value |
| CLEAN | Removes all non-printable characters from the text |
| CONCAT | Joins several text items into one text item |
| ENDS | Checks to see the first text value ends with the second text value |
| EXACT | Checks to see if two text or choice values are identical (case-sensitive) |
| FIND | Finds the position of one text value within another (case-sensitive) |
| LEFT | Returns the leftmost characters from a text value |
| LEFTPAD | Left pad the text with the given character a number of times |
| LEN | Returns the number of characters in a text value |
| LOWER | Converts text to lowercase |
| MID | Returns a specific number of characters from a text value starting at the given position |
| PROPER | Capitalizes the first letter in each word in the text |
| REGEX_REPLACE | Replaces characters within the text matching the specified regular expression pattern with new text |
| REGEX_SEARCH | Finds a matching regular expression pattern within a text value and returns the relative position of that match |
| REPLACE | Replaces matching parts of text with a replacement text value |
| REPT | Repeats text a given number of times |
| RIGHT | Returns the rightmost characters from a text value |
| SEARCH | Finds the position of one text value within another (case-insensitive) |
| SUBSTITUTE | Substitutes new text for old text in a text value |
| TRIM | Removes spaces from text |
| UPPER | Converts text to uppercase |
| VALUE | Convert text to a number |
Number functions
Functions for handling Number values.
| Function | Description |
|---|---|
| ABS | Returns the absolute value of a number |
| DECIMALS | Returns the number of decimal places in the given number |
| INT | Rounds a number down to the nearest whole number |
| MOD | Returns the remainder after division |
| RAND | Returns a random number between 0 and 1 |
| ROUND | Rounds a number to a specified number of digits |
| TEXT | Formats a value and converts it to text |
Logical functions
Functions for handling Logcial values.
| Function | Description |
|---|---|
| AND | Returns TRUE if all logical conditions are TRUE |
| FALSE | Returns the logical value FALSE |
| IF | Returns the first value if the logical condition is TRUE otherwise return the second value |
| IFS | Checks whether one or more logical conditions are TRUE and returns a value that corresponds to the first TRUE condition |
| NOT | Reverses a logical value |
| OR | Returns TRUE if any logical condition is TRUE |
| TEXT | Formats a value and converts it to text |
| TRUE | Returns the logical value TRUE |
Date and Time functions
Functions for handling Date, Time and Date/Time values.
| Function | Description |
|---|---|
| DATE | Create a date from the year, month and day |
| DATEVALUE | Create a date from the text value |
| DAY | Return the day of the month from a date as an integer between 1 and 31 |
| DAYS | Returns the number of days between two dates |
| EDATE | Returns the date adjusted by the number of months before or after the start date |
| EPOCH | Returns the number of milliseconds since 1 January 1970 as a number |
| HOUR | Returns the hour of a time or date/time value |
| MINUTE | Returns the minute of a time or date/time value |
| MONTH | Returns the month of a date or date/time value |
| NETWORKDAYS | Returns the number of whole workdays between two dates |
| NOW | Returns the current date and time |
| SECOND | Returns the seconds of a time or date/time value |
| TEXT | Formats a value and converts it to text |
| TIME | Create a time from the hour, minute and second |
| TIMEVALUE | Create a time from the text value |
| TODAY | Returns the current date |
| WEEKDAY | Returns the day of the week of a date or date/time ranging from 1 (Sunday) to 7 (Saturday) |
| YEAR | Returns the year of a date or date/time value |
Array functions
Functions for working with an Array of items.
| Function | Description |
|---|---|
| APPEND | Adds the items from the second array to the end of the first array |
| COUNT | Counts how many numbers are in the array |
| COUNTA | Counts the non-blank items in array |
| COUNTALL | Count all items in the array, including blank items |
| COUNTBLANK | Counts only blank items in an array |
| COUNTIF | Counts the number of items in the array that meet the given criteria |
| COUNTMATCH | Counts the number of items in the array that match the regular expression pattern |
| CREATE | Creates an array using the values provided |
| DELETE | Delete the item in the array at the specified position |
| FILL | Create an array with the specified number of items, each filled with the given value |
| FIRST | Returns the first item from an array |
| INDEX | Returns an item from an array at the position given |
| INSERT | Insert an item into an array at the position given |
| LAST | Returns the last item from an array |
| MATCH | Searches for a specified value in an array and returns the relative position of that value |
| REGEX_MATCH | Check if text matches the specified regular expression pattern |
| SUM | Sum together value of all array items |
Other functions
Other miscellaneous functions.
| Function | Description |
|---|---|
| ASSERT | Generate a specific validation error message if the logical condition evaluates to FALSE |
| ISBLANK | Returns TRUE if the value is blank |
| ISDATE | Returns TRUE if the value is a date |
| ISEVEN | Returns TRUE if the number is even |
| ISNUMBER | Returns TRUE if the value is a number |
| ISODD | Returns TRUE if the number is odd |
| ISTEXT | Returns TRUE if the value is text |
| ISTIME | Returns TRUE if the value is a time |
| NOTBLANK | Returns TRUE if a value is present |
ON THIS PAGE