📚
Actiondesk Knowledge base
🧮

List of formulas supported

List of formulas and parameters

FormulaSummaryExampleAvailable?
AMA
GPT-3Given a range as a "training dataset", returns a similar patternGPT-3(A1:B4, "France")Being worked on
IncludeReturns TRUE if the string contains the substring, FALSE otherwiseINCLUDE("string", "is the word string in this sentence?)Yes
Timestamp_to_dateReturns a date with the format "MM-DD-YYYY". Takes a UNIX timestamp (in seconds) as argument.TIMESTAMPTODATE(308966400)Yes
LookupSearches 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 lookupLOOKUP(#customerid, ‘Sheet2!’#id, ‘Sheet2!’#name)Yes
CountuniqueifsCounts 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
CountuniqueCounts the number of unique values in a column.COUNTUNIQUE(#user_name)Yes
YearReturns the year of a specific dateYEAR("10/17/1979")Yes
MonthReturns the month of a specific date, in numeric formatMONTH("10/17/1979")Yes
UpperNo
RightReturns a substring from the end of a specified string.RIGHT("Actiondesk", 4)No
IferrorReturns 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
LeftReturns a substring from the beginning of a specified string.LEFT("Actiondesk", 6)No
DateConverts a provided year, month, and day into a date.DATE(1979, 10, 17) Being worked on
AverageReturns the average value of a datasetAVERAGE(#selling_price)Yes
AverageifsReturns the average of a column depending on multiple criteria.AVERAGEIFS(#selling_price, #product_category, "phones", #country, "France")Yes
WeeknumReturns the week numberWEEKNUM("10/17/1979")Yes
FalseReturns the logical value FALSEFALSE()No
TrueReturns the logical value TRUETRUE()Yes
IserrorChecks whether a value is an error. Will return TRUE or FALSEISERROR(10/0)Being worked on
DayReturns the day of the month of a specific date, in numeric format.DAY("10/17/1979")No
WeekdayDay of the week of the date provided (as a number)WEEKDAY("10/17/1979")No
VlookupNo
TextNo
SearchNo
ReplaceNo
NowNo
LowerNo
lenNo
FloorNo
CeilingNo
DaysNo
SumifReturns the sum of a column depending on one criteria.SUMIF(#price, #product_category, "Phones")Yes
CountifReturns the count of a column depending on one criteria.COUNTIF(#product_category, "Phones")Yes
IndexNo
DatevalueNo
DatedifNo
SumproductNo
IslogicalNo
ProperNo
XlookupNo
ConcatenateNo
IfsNo
PercentileNo
IsnumberNo
MinifsNo
IstextNo
MatchNo
PercentileifNo
IsblankNo
RankNo
MaxifsNo
XorNo
RoundRounds a number to a certain number of decimal places, always rounding down to the next valid increment.ROUNDDOWN(99.44, 1)Yes
RoundupRounds a number to a certain number of decimal places, always rounding up to the next valid increment.ROUNDUP(99.44, 1)Yes
RounddownRounds a number to a certain number of decimal places according to standard rules.ROUND(99.44, 1)Yes
PMTCalculates 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
TodayReturns the current date.TODAY()Yes
OrReturns 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
AndReturns 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
IntRounds a number down to the nearest integer that is less than or equal to it.INT(24.8)Yes
NotReturns the opposite of a logical value - NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE.NOT(TRUE)Yes
IfReturns 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
NetworkdaysReturns the number of net working days between two provided dates.NETWORKDAYS(A1, B1, C1:C10)Yes
MaxReturns the maximum value in a numeric dataset.MAX(A3, 42)Yes
MinReturns the minimum value in a numeric dataset.MIN(A3, 5)Yes
CountaReturns the number of values in a columnCOUNTA(#booking_id)Yes
SumReturns the sum of a series of numbers and/or cells or of a columnSUM(A2:A100, 101) or SUM(#price)Yes
CountifsReturns the count of a column depending on multiple criteria.COUNTIFS(#product_category, "Phones", #booking_date, ">"&E3)Yes
SumifsReturns the sum of a column depending on multiple criteria.SUMIFS(#price, #product_category, "Phones", #booking_date, ">"&E3)Yes