Standard functions: Difference between revisions
From Planfix
| (26 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
{{#seo: | |||
|title=Functions in Planfix | |||
|titlemode=append | |||
|keywords=function. planfix, reports, calculated fields | |||
|description=Functions in Planfix | |||
}} | |||
Planfix supports standard operations for formulas in [[Reports: Formulas | reports]] and [[Calculated fields | calculated fields]]. At the moment, you can use the following operations and functions in formulas: | Planfix supports standard operations for formulas in [[Reports: Formulas | reports]] and [[Calculated fields | calculated fields]]. At the moment, you can use the following operations and functions in formulas: | ||
==Standard operations== | |||
''' | *addition '''+''' | ||
*subtraction '''-''' | |||
*multiplication '''*''' | |||
*subtraction - | *division '''/''' | ||
*multiplication * | *parentheses '''()''' | ||
*division / | *greater than '''>''' | ||
*parentheses ( ) | *less than '''<''' | ||
*equals '''=''' | |||
*greater than or equal to '''>=''' | |||
*less than or equal to '''<=''' | |||
*not equal to '''!=''' | |||
*raise to the power '''^''' | |||
*logical AND '''&&''' -[https://planfix.com/help/AND_Function#Example_%E2%84%96_2 example] | |||
*logical OR '''||''' - example] | |||
==Functions== | ==Functions== | ||
*[[IF Function]] | *[[IF Function]] | ||
*[[AND Function]] | *[[AND Function]] | ||
*[[OR Function]] | *[[OR Function]] | ||
==String functions== | ==String functions== | ||
*[[CONTAIN Function]] | *[[CONTAIN Function]] | ||
| Line 27: | Line 37: | ||
*[[SEARCH function|SEARCH Function]] | *[[SEARCH function|SEARCH Function]] | ||
*[[MD5 Function]] | *[[MD5 Function]] | ||
*[[SHA256 Function]] | |||
*[[HMACMD5 Function]] | |||
*[[HMACSHA256 Function]] | |||
*[[ENCODEURL Function]] | *[[ENCODEURL Function]] | ||
*[[UPPER Function]] | *[[UPPER Function]] | ||
| Line 33: | Line 46: | ||
*[[REGEXPFIND Function]] | *[[REGEXPFIND Function]] | ||
*[[BASE64ENCODE Function]] | *[[BASE64ENCODE Function]] | ||
*[[GUID Function]] | |||
*[[MD2HTML Function]] | |||
==Number functions== | ==Number functions== | ||
*[[ROUND Function]] | *[[ROUND Function]] | ||
| Line 52: | Line 66: | ||
*[[RAND function|RAND Function]] | *[[RAND function|RAND Function]] | ||
*[[RANDBETWEEN function|RANDBETWEEN Function]] | *[[RANDBETWEEN function|RANDBETWEEN Function]] | ||
==Date functions== | ==Date functions== | ||
*[[NOW Function]] | *[[NOW Function]] | ||
| Line 58: | Line 71: | ||
*[[DATE Function]] | *[[DATE Function]] | ||
*[[DATEONLY Function]] | *[[DATEONLY Function]] | ||
*[[ | *[[DATEDIF Function]] | ||
*[[TIME Function]] | *[[TIME Function]] | ||
*[[EDATE Function]] | *[[EDATE Function]] | ||
| Line 67: | Line 80: | ||
*[[DAY Function]] | *[[DAY Function]] | ||
*[[MONTH Function]] | *[[MONTH Function]] | ||
*[[QUARTER Function]] | |||
*[[YEAR Function]] | *[[YEAR Function]] | ||
*[[HOUR Function]] | *[[HOUR Function]] | ||
| Line 72: | Line 86: | ||
*[[SECOND Function]] | *[[SECOND Function]] | ||
*[[ADDMINUTES Function]] | *[[ADDMINUTES Function]] | ||
*[[ | *[[ADDHOURS Function]] | ||
*[[ | *[[EOMONTH Function]] | ||
*[[ISWORKDAY Function]] | *[[ISWORKDAY Function]] | ||
*[[WORKDAY Function]] | *[[WORKDAY Function]] | ||
*[[NETWORKDAYS Function]] | *[[NETWORKDAYS Function]] | ||
*[[TEXT Function #Formatting dates]] | |||
*[[DATEINWORDS Function]] | |||
== Functions for variables with a set of values == | == Functions for variables with a set of values == | ||
*[[UNIQUE Function]] | |||
*[[SUM Function]] | *[[SUM Function]] | ||
*[[SUMIF Function]] | *[[SUMIF Function]] | ||
*[[TEXTJOIN Function]] | |||
*[[COUNTIF Function]] | |||
*[[JSONARRAY Function]] | |||
== Functions available in document templates == | |||
*[[SUM Function]] | |||
== Additional == | == Additional == | ||
| Line 86: | Line 108: | ||
*[[Variables in Text]] | *[[Variables in Text]] | ||
*[[Functions in document templates]] | *[[Functions in document templates]] | ||
*[[Escaping quotes]] | |||
== Go To == | == Go To == | ||
*[[Reports: Formulas]] | *[[Reports: Formulas]] | ||
*[[Types of custom fields]] | *[[Types of custom fields]] | ||
Latest revision as of 08:39, 24 March 2025
Planfix supports standard operations for formulas in reports and calculated fields. At the moment, you can use the following operations and functions in formulas:
Standard operations
- addition +
- subtraction -
- multiplication *
- division /
- parentheses ()
- greater than >
- less than <
- equals =
- greater than or equal to >=
- less than or equal to <=
- not equal to !=
- raise to the power ^
- logical AND && -example
- logical OR || - example]
Functions
String functions
- CONTAIN Function
- CONCATENATE Function
- SUBSTITUTE Function
- LEFT Function
- RIGHT Function
- LEN Function
- MID Function
- CHAR Function
- FIND Function
- SEARCH Function
- MD5 Function
- SHA256 Function
- HMACMD5 Function
- HMACSHA256 Function
- ENCODEURL Function
- UPPER Function
- LOWER Function
- PROPER Function
- REGEXPFIND Function
- BASE64ENCODE Function
- GUID Function
- MD2HTML Function
Number functions
- ROUND Function
- MROUND Function
- ROUNDUP Function
- ROUNDDOWN Function
- TEXT Function
- POWER Function
- MOD Function
- ABS Function
- SQRT Function
- SIN Function
- COS Function
- RADIANS Function
- PI Function
- ASIN Function
- ACOS Function
- RAND Function
- RANDBETWEEN Function
Date functions
- NOW Function
- CNOW Function
- DATE Function
- DATEONLY Function
- DATEDIF Function
- TIME Function
- EDATE Function
- DATEVALUE Function
- TIMEVALUE Function
- WEEKDAY Function
- WEEKNUM Function
- DAY Function
- MONTH Function
- QUARTER Function
- YEAR Function
- HOUR Function
- MINUTE Function
- SECOND Function
- ADDMINUTES Function
- ADDHOURS Function
- EOMONTH Function
- ISWORKDAY Function
- WORKDAY Function
- NETWORKDAYS Function
- TEXT Function #Formatting dates
- DATEINWORDS Function
Functions for variables with a set of values
Functions available in document templates
Additional