Where can I use formulas

Formulas can be used in the several contexts, in most cases, if you find =formula label inside a field, this field accepts formulas.

 

  1. Spreadsheet and Table cell content - Formulas that return value have to match a cell type


  2. Section Data and New row formula - Lookup formulas only


  3. Section Visibility - Formulas have to return boolean type (true, false)


  4. Table Column - Visibility (boolean) and Header (text)


  5. Diagram Title (text), and X Axis and Y Axis options - Title (Text), Min (Number), Max (Number), Step(Number), Categories (Array of texts)


  6. Diagram Series options - Name (Text), Color (Text), Data Formula (scalar or array) see article about diagrams for more


  7. Slider Cell Address - only Spreadsheet cell address supported


  8. App’s Document Name option (Text)


  9. KPI - Responsible Person - Text formula should return email


  10. Dropdown and Autocomplete cells Items option (Array of texts)


  11. Workflow State - Task Message (Text)


  12. Workflow Action - Execution condition (Boolean)


  13. Workflow ActionStep - Parameters - Formula type depends on parameter
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk