Formulas
Use formulas to perform powerful operations and calculations in your solutions.
By Peter and 1 other2 authors11 articles
- What is a Formula field and how do I add one: Introduction to FormulasFormula fields compute a value from other fields: arithmetic, conditions or combined text. Add one, write the formula and it updates itself.
- What formulas can I copy for totals, text, dates and status: Formula ExamplesCopy-ready formulas for totals, combined text, character counts, date differences, scores from Select values, conditional sums and age.
- Create and Edit Formulas
- Formula RestrictionsThe short list of formula field limitations and restrictions
- How do I combine fields into one text value: Combine Text from Two or More FieldsJoin field values and text with the + operator or CONCAT in a Formula field, for labels such as Customer-Region or Year Make Model.
- How do I use data from a linked table in a formula: Reference Data from other TablesReach fields in linked records with [Link].[Field] dot notation and reduce lists with SUM, COUNT, MIN, MAX, AVG or SUMIF.
- Formula Field Error MessagesFormula field errors and what they mean
- Date Based FormulasCompare or adjust dates in your SmartSuite formulas
- Formatting Formula ResultsLearn how to take your formulas to the next level by formatting the formula output!
- Formula Frequently Asked QuestionsYour guide to common questions and solutions about using formulas in SmartSuite.
- Which functions and operators can I use in a formula: Formula Functions & OperatorsThe complete list of SmartSuite formula operators and functions, with the syntax and an example for each.