Formula, Syntax

May I know what’s function available to be used in formula? And also what’s the syntax/language to use?

We have 3 ways to do logic:

  1. Formula
    Most if not all excel formula functions can be done. It is very similar to python but simpler for example:
    Formula Script Total/Sum - Updated

  2. Automation Blocks
    UI Drag and Drop to create, edit, perform an activity, trigger API requests etc.

  3. Custom Scripts
    Python scripting interface