ActivityInfo
Features
Pricing
Support
News
Contact us
Log in
Menu
Log in
Documentation
Templates
Training
Webinars
Consulting
Features
Form designer
Report designer
Integrations
Data entry
All features
New features
Pricing
Subscriptions
Onboarding
Partnerships
Support
Documentation
Templates
Training
Webinars
Consulting
News
Contact us
Support
Documentation
Formulas
Formulas
Logical Functions
AND (&&)
OR (||)
IF
NOT (!)
EQUAL (==)
NOT EQUAL (!=)
GREATER (>)
GREATER OR EQUAL (>=)
LESS (<)
LESS OR EQUAL (<=)
ISNUMBER
ISBLANK
Text Functions
SEARCH
CONCAT
LEFT
RIGHT
MID
REGEXMATCH
REGEXREPLACE
REGEXEXTRACT
VALUE
Date & Time Functions
TODAY
DATE
ADDDATE
DAY
MONTH
QUARTER
YEAR
DAYS
YEARFRAC
Statistical Functions
SUM
AVERAGE
MEDIAN
MAX
MIN
COUNT
COUNTDISTINCT
Mathematical Functions
ADD (+)
SUBTRACT (-)
MULTIPLY (*)
DIVIDE (/)
CEIL
FLOOR
POWER
GREAT_CIRCLE
Miscellaneous Functions
COALESCE