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.
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
Related Articles