Creating Formulas for Freeform Grids
Freeform grids leverage diverse data sources in integrated dynamic calculations. Cell references use syntax that matches those supported by Microsoft Excel, where the column letter and the row number indicate the cell address.
Example: =SUM(B8:C8) adds the data values from the cell on the eighth row of the B column to the eighth row of the C column.
Note: | Formula cell addresses are absolute. They do not dynamically change themselves to accommodate the displacement caused by adding or removing rows or columns. As a result, you should not compose freeform grid formulas until you are finished with all other grid formatting. |
You can enter these functions in cells or the Formula bar.
OPERATOR_ADD=+
OPERATOR_SUBSTRACT=-
OPERATOR_DIVIDE=/
OPERATOR_MULTIPLY=*
OPERATOR_POWER=^
OPERATOR_EQUAL==
OPERATOR_DIFFERENT=<>
OPERATOR_GREATER_OR_EQUAL=>=
OPERATOR_LESS_OR_EQUAL=<=
OPERATOR_GREATER=>
OPERATOR_LESS=<
CONDITION_IF=IF
CONDITION_THEN=THEN
CONDITION_ELSE=ELSE
FUNCTION_LN=LN
FUNCTION_LOG=LOG10
FUNCTION_EXP=EXP
FUNCTION_SQRT=ROOT
FUNCTION_COS=COS
FUNCTION_SIN=SIN
FUNCTION_TAN=TAN
FUNCTION_ACOS=ACOS
FUNCTION_ASIN=ASIN
FUNCTION_ATAN=ATAN
FUNCTION_COSH=COSH
FUNCTION_SINH=SINH
FUNCTION_TANH=TANH
FUNCTION_INTEGER=INT
FUNCTION_ABS=ABS
FUNCTION_NOT=NOT
JEKS_FUNCTION_SUM=SUM
JEKS_FUNCTION_RAND=RAND
JEKS_FUNCTION_MODULO=MOD
JEKS_FUNCTION_FACT=FACT
JEKS_FUNCTION_IF=IF
JEKS_FUNCTION_AND=AND
JEKS_FUNCTION_OR=OR
JEKS_FUNCTION_TRUE=TRUE
JEKS_FUNCTION_FALSE=FALSE
JEKS_FUNCTION_DATE=DATE
JEKS_FUNCTION_DATEVALUE=DATEVALUE
JEKS_FUNCTION_NOW=NOW
JEKS_FUNCTION_TIME=TIME
JEKS_FUNCTION_TIMEVALUE=TIMEVALUE
JEKS_FUNCTION_YEAR=YEAR
JEKS_FUNCTION_MONTH=MONTH
JEKS_FUNCTION_DAY=DAY
JEKS_FUNCTION_WEEKDAY=WEEKDAY
JEKS_FUNCTION_HOUR=HOUR
JEKS_FUNCTION_MINUTE=MINUTE
JEKS_FUNCTION_SECOND=SECOND
JEKS_FUNCTION_CHAR=CHAR
JEKS_FUNCTION_FIND=FIND
JEKS_FUNCTION_CODE=CODE
These conditional operators are also supported: