Yes, a formula can reference fields in the current Table, a field in a Sub-Items field, or a Field in another Table using a Linked Record field. Learn more about this in our article Reference Data from other Tables.

This particular calculation error occurs because one of the referenced values is a text value, not a number. The addition operator (+) serves double-duty in SmartSuite formulas, either adding numbers together if both values are numeric, or combining (concatenating) values to create a custom bit of text if anything other than numbers are referenced (i.e. dates or text).

To correct this error, check that both values referenced by your formula are numeric types.

Note 📝 : The formula field is treated by SmartSuite as either a number, a date, or as text. If the addition operator is adding numbers you get a number result (allowing for numeric field filtering, charting, etc.) If you are concatenating values, the output is text (so you get access to "contains" and similar filters).

If your formula's value is a red icon, you've got an error in the formula and SmartSuite cannot calculate a value. Click on the icon as a Solution Manager or Admin to open the formula field properties and fix the formula syntax.

Note that the warning "Invalid formula" will be displayed in red text below the formula builder text box if the formula is currently invalid.

Absolutely - and this is one of the most common uses for the SmartSuite formula field. See our article Combine text from two or more fields for a complete, step-by-step tutorial.

We've assembled the SmartSuite Formula Field Reference Guide to answer all of your formula function and operator questions! This comprehensive document gives you a list of everything the formula field currently supports, proper syntax, and illustrative examples of each function in use. Enjoy!