Formula fields provide SmartSuite Solution Owners with a lot of power and flexibility, but there are a few things that you should keep in mind when planning to use them in your solutions.
Note: Formula fields can reference other Formula fields.
Field Limit Note:
The limit for complex field types in Tables vary based on plan type & include:
Free / Team Plan
30 Linked Records
30 Lookups
30 Total Calculated fields, including: Formulas, Rollups, Counts
Professional Plan
50 Linked Records
50 Lookups
50 Total Calculated fields, including: Formulas, Rollups, Counts
Enterprise / Signature Plan
100 Linked Records
100 Lookups
100 Total Calculated fields, including: Formulas, Rollups, Counts
Limitations to conditional logic (IF statements and similar)
Any conditional logic statement such as IF or SUMIF must return the same type for every possible response. In other words, your IF statement cannot return a date for its TRUE response and a number for its FALSE response.
This rule applies to nested conditional functions (nested IF statements for example). If one response returns a date, every possible response must return a date or the function will generate an error.
Lookup Fields are not supported
Lookup type fields are not supported in formulas.
If you need the lookup value in your calculation, you can reference them through the appropriate Linked Record field, like this:
[Linked Record].[Field that is your Lookup target]
Other unsupported fields
There are a few additional fields that aren't supported in formulas. They include the following types:
Files and Images
Checklist
Signature
SmartDoc
Time Tracking Log