Create and Edit Formulas
Peter Novosel avatar
Written by Peter Novosel
Updated over a week ago

Use formulas to calculate numeric values or automate your Table. Create a formula that calculates total price based on quantity ordered, combines the values of multiple fields, or uses conditional logic to create a value based on criteria you specify.


Working With Formulas

Formula Operators & Functions

We've put together a list of all Formatting, Functions, & Operators as an area to easily reference everything you need to know about how to use a Formula Field, or we also have a help article with the Operators and Functions as well.


Create a new Formula Field

Start Here: Learn How to Add or Modify Any Field type in SmartSuite

Formula Fields are added in the same way as any other SmartSuite field - just click the "+" symbol in grid view or select Add New Field in the Record Display view (as a Solution Manager or Admin, of course!)

From there, the Edit Formula dialog is displayed, allowing you create your formula and view information about the fields, operators, and functions available. You can create/modify your formulas in two edit modes - simple and advanced.

Simple Editor

This mode allows you to make changes into your formulas using basic functions, such as addition (+), subtraction (-), multiplication (*), or division (÷). With this editor, you can only select fields from the list.

Advanced Editor

From there, the Edit Formula dialog is displayed, allowing you create your formula and view information about the fields, operators, and functions available.


Edit a Formula Field

Edit a Formula Field by selecting "Modify Field Settings" from the field options menu in Record View or from the Field dropdown in any Grid view.


Formulas With Errors

If your formula isn't quite right and is saved in an errored state, no worries - SmartSuite will let you know! In Grid View, Formula Fields that are invalid display a red icon, like this:

Solution Managers can click the icon to open a formula editor dialog. Note that this interface is slightly different from the one accessed from the field properties link, as it is streamlined a bit so that you can focus on fixing your formula. Here's what it looks like:

Once you've fixed the problem, simply click Calculate and the formula will be saved and your records will update with calculated values.


If You're Migrating From Airtable

If you're used to Airtable's formula syntax, it's important to know that there are a few differences when creating formulas in SmartSuite. Here is a short summary of Airtable formula functions and their SmartSuite equivalent:

Airtable Formatting

SmartSuite Equivalent

' '

" "

&

+

{ }

[ ]

TONOW(), FROMNOW(), DATETIME_DIFF()

DATEDIFF()

CONCATENATE()

CONCAT()

LEN()

LENGTH()

COUNTA()

COUNT()

WEEKNUM()

WEEK()

Did this answer your question?