In Actiondesk, there are many functions accessible to perform logic or calculation on your data. A large majority of these functions have the same name and behave the same way as in Excel.
You have access to those functions when adding a column or filtering through your data.

Here's the complete list of the currently available functions.

ABS
Returns the absolute value of a number
Parameters: ["value"]
Ex: ABS(-4) will return 4

ADD
Returns the sum of two numbers. Equivalent to the + operator
Parameters: ["value1", "value2"]
Is equivalent to value1 + value2
Ex: ADD(3,4) will return 7

AND
Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false
Parameters: ["logical_expression1", "[logical_expression2, '...']"]

AVERAGE
Returns the numerical average value in a dataset, ignoring text
Parameters: ["value1", "[value2, '...']"]
AVERAGE(4,8) will return 6

CEILING
Rounds a number up to the nearest integer multiple of specified significance
Parameters: ["value", "[factor]"]
Ex: CEILING(3.24, 1) will return 4 ; CEILING(3,24; 0,1) will return 3.3

CLEAN
Returns the text with the non-printable ASCII characters removed
Parameters: ["text"]

CONCATENATE
Appends strings to one another
Parameters: ["string1, [string2, '...']"]
Ex: Concatenate("this is", "a test") will return "this is a test"

DATE
Converts a provided year, month, and day into a date
Parameters: ["year, month, day"]

DAY
Returns the day of the month that a specific date falls on, in numeric format
Parameters: ["date"]
Ex: DAY(2018-05-02) will return 2

DAYS
Returns the number of days between two dates
Parameters: ["end_date, start_date"]
Ex: DAYS(2018-05-02, 2018-05-10) will return 8

EVEN
Rounds a number up to the nearest even integer
Parameters: ["value"]
Ex: EVEN(3) will return 4

EXACT
Tests whether two strings are identical
Parameters: ["string1, string2"]
Is equivalent to "string1"="string2"

FALSE
Returns the logical value FALSE
Parameters: [""]

FLOOR
Rounds a number down to the nearest integer multiple of specified significance
Parameters: ["value", "[factor]"]
Ex: FLOOR(3.24, 1) will return 3 ; FLOOR(3,24; 0,1) will return 3.2

HOUR
Returns the hour component of a specific time, in numeric format
Parameters: ["time"]
Ex: HOUR(2018-05-16 11:11:07.00) will return 11

IF
Returns one value if a logical expression is TRUE and another if it is FALSE
Parameters: ["logical_expression, value_if_true, value_if_false"]
Ex: IF(3=x, "Yes", "No") will return "Yes" if x is equal to 3, "No" otherwise

IFERROR
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
Parameters: ["value, value_if_error"]
Ex: IFERROR(3/0, 0) will return 0, but IFERROR(3+2,0) will return 5

ISBLANK
Checks whether the referenced cell is empty
Parameters: ["value"]

ISERROR
Checks whether the referenced cell is an error.
Parameters: ["value"]
Ex: ISERROR(3/0) will return TRUE

ISEVEN
Checks whether the provided value is even.',
Parameters: ["value"],

ISLOGICAL
Checks whether a value is TRUE or FALSE.',
Parameters: ["value"]

ISNONTEXT
Checks whether a value is non-textual
Parameters: ["value"]

ISNUMBER
Checks whether a value is a number.
Parameters: ["value"]

ISNULL
Checks whether a value is null
Parameters: ["value"]

ISODD
Checks whether the provided value is odd.
Parameters: ["value"]

ISTEXT
Checks whether a value is text
Parameters: ["value"]

LEFT
Returns a substring from the beginning of a specified string
Parameters: ["string, [number_of_characters]"]
Ex: LEFT("this is a test", 4) will return "this"

LEN
Returns the length of a string
Parameters: ["text"]
LEN("this is a test") will return 14

LOWER
Converts a specified string to lowercase.
Parameters: ["text"]
Ex: LOWER("CAPITAL") will be "capital"

MAX
Returns the maximum value in a numeric dataset
Parameters: ["value1", "[value2, '...']"]
Ex: MAX(4, 6) will return 6

MINUTE
Returns the minute component of a specific time, in numeric format
Parameters: ["time"]
Ex: MINUTE(2018-05-16 11:11:07.00) will return 11

DAY
Returns the month of the year that a specific date falls on, in numeric format
Parameters: ["date"]
Ex: MONTH(2018-05-02) will return 5

NOT
Returns the opposite of a logical value
Parameters: ["logical_expression"],
Ex: NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE

NOW
Returns the current date and time as a date value
Parameters: [""]

TIMESTAMPNOW
Returns the current date and time as a timestamp
Parameters: [""]

ODD
Rounds a number up to the nearest odd integer
Parameters: ["value"]
Ex: ODD(2) will return 3

OR
Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false
Parameters: ["logical_expression1", "[logical_expression2, '...']"]

POWER
Returns a number raised to a power
Parameters: ["base", "exponent"]

PRODUCT
Returns the result of multiplying a series of numbers together
Parameters: ["factor1", "[factor2, '...']"]
Is equivalent to factor1factor2

QUOTIENT
Returns one number divided by another
Parameters: ["dividend", "divisor"]
Is equivalent to divident / divisor

RIGHT
Returns a substring from the end of a specified string
Parameters: ["string", "[number_of_characters]"]
Ex: RIGHT("this is a test", 4) will return "test"

SECOND
Returns the second component of a specific time, in numeric format
Parameters: ["time"]
Ex: SECOND(2018-05-16 11:11:07.00) will return 7

SQRT
Returns the positive square root of a positive number
Parameters: ["value"]

TODAY
Returns the current date as a date value
Parameters: [""],

TO_TEXT
Converts a provided numeric value to a text value
Parameters: ["value"]

TRUE
Returns the logical value TRUE
Parameters: [""]

UPPER
Converts a specified string to uppercase
Parameters: ["text"]

VALUE
Converts a string in any of the date, time or number formats that Actiondesk understands into a number
Parameters: ["text"]

WEEKDAY
Returns a number representing the day of the week of the date provided
Parameters: ["date", "[type]"]
Ex: WEEKDAY(2018-05-16 11:11:07.00) will return 2

WEEKNUM
Returns a number representing the week of the year where the provided date falls
Parameters: ["date", "[type]"]
Ex: WEEKNUM(2018-05-16 11:11:07.00) will return 20

XOR
Returns a logical exclusive OR of all arguments. Will return true only of both parameters are of a different boolean value (so if one is true and the other false)
Parameters: ["logical_expression1", "logical_expression2"]
Ex:

YEAR
Returns the year specified by a given date
Parameters: ["date"]
Ex: YEAR(2018-05-02) will return 2018

TIMESTAMPTODATETIME
Returns a date format
Parameters: ["timestamp"]
Ex: TIMESTAMPTODATETIME(1532367738529) will return 2018-07-23T17:42:18.529Z

DATETIMETOTIMESTAMP
Returns a timestamp (in seconds or milliseconds)
Parameters: ["datetime","unit"]
Ex: DATETIMETOTIMESTAMP(2018-07-23T17:42:18.529Z,"milliseconds") will return 1532367738529
Comment: If you want to update a date in a business application (Hubspot for exemple), you have to format the field with a timestamp hence the use of this formula.
Was this article helpful?
Cancel
Thank you!