Standard functions: Difference between revisions

From Planfix
Jump to: navigation, search
No edit summary
 
(18 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==
==Standard operations==
*addition '''+'''  
*addition '''+'''  
Line 14: Line 19:
*not equal to '''!='''  
*not equal to '''!='''  
*raise to the power '''^'''  
*raise to the power '''^'''  
*logical AND '''&&''' -[https://planfix.com/ru/help/%D0%A4%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D1%8F_%D0%98#.D0.90.D0.BB.D1.8C.D1.82.D0.B5.D1.80.D0.BD.D0.B0.D1.82.D0.B8.D0.B2.D0.BD.D0.BE.D0.B5_.D0.B8.D1.81.D0.BF.D0.BE.D0.BB.D1.8C.D0.B7.D0.BE.D0.B2.D0.B0.D0.BD.D0.B8.D0.B5 example]
*logical AND '''&&''' -[https://planfix.com/help/AND_Function#Example_%E2%84%96_2 example]
*logical OR  '''||''' - [https://planfix.com/ru/help/%D0%A4%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D1%8F_%D0%98%D0%9B%D0%98#.D0.90.D0.BB.D1.8C.D1.82.D0.B5.D1.80.D0.BD.D0.B0.D1.82.D0.B8.D0.B2.D0.BD.D0.BE.D0.B5_.D0.B8.D1.81.D0.BF.D0.BE.D0.BB.D1.8C.D0.B7.D0.BE.D0.B2.D0.B0.D0.BD.D0.B8.D0.B5 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 34: 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 40: Line 46:
*[[REGEXPFIND Function]]
*[[REGEXPFIND Function]]
*[[BASE64ENCODE Function]]
*[[BASE64ENCODE Function]]
 
*[[GUID Function]]
*[[MD2HTML Function]]
==Number functions==
==Number functions==
*[[ROUND Function]]
*[[ROUND Function]]
Line 59: 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 65: Line 71:
*[[DATE Function]]
*[[DATE Function]]
*[[DATEONLY Function]]
*[[DATEONLY Function]]
*[[DATEIF Function]]
*[[DATEDIF Function]]
*[[TIME Function]]
*[[TIME Function]]
*[[EDATE Function]]
*[[EDATE Function]]
Line 74: Line 80:
*[[DAY Function]]
*[[DAY Function]]
*[[MONTH Function]]
*[[MONTH Function]]
*[[QUARTER Function]]
*[[YEAR Function]]
*[[YEAR Function]]
*[[HOUR Function]]
*[[HOUR Function]]
Line 79: Line 86:
*[[SECOND Function]]
*[[SECOND Function]]
*[[ADDMINUTES Function]]
*[[ADDMINUTES Function]]
*[[ADDHOUR Function]]
*[[ADDHOURS Function]]
*[[EMONTH 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 94: Line 109:
*[[Functions in document templates]]
*[[Functions in document templates]]
*[[Escaping quotes]]
*[[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

Number functions

Date functions

Functions for variables with a set of values

Functions available in document templates

Additional


Go To