Tutorial: Calculated Fields

Learn how to use Calculated fields

Find tutorials here below. We will keep adding more videos to the list as we go.

Introduction to Calculated Fields

Watch an introduction video above or follow our tutorials and learn the basics of Calculated Fields.

From Start date to Now

Calculate the difference between a specific date and time and now (in seconds). In this tutorial, we use the following example:

DateDiff(Field("Created date"),Now())

Switch values from a field to something else

Create a calculated field that displays "🇫🇷" if the value in another field is "FR" or "🇺🇸" if the value in another field is "US." In this tutorial, we use the following example:

Switch( Field("Organization address country") == "FR", "🇫🇷", Field("Organization address country") == "DK", "🇩🇰", Field("Organization address country") == "ES", "🇪🇸", Field("Organization address country") == "US", "🇺🇸" )

From Start date to End date

Calculate the difference between two date fields (in seconds). In this tutorial, we use the following example:

DateDiff(Field("Created date"),Field("Close date"))