Skip to main content
Formula Restrictions

The short list of formula field limitations and restrictions

Peter Novosel avatar
Written by Peter Novosel
Updated yesterday

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

Did this answer your question?