In order to create a formula, we should first choose the field type of the result; it can be a text, number, date, boolean, website link or a currency.
After choosing the field type of the end result, we can start creating our formula by clicking on the box below ('to be computed'). On the list that will open we can see the fields we have and the operands we can use. A formula can start with a field or with an operands such as MIN(), MAX(), COUNT() or MonthName...
Example - 1 :
We have a social media planning app and we want to automatically add the character count of the post, in order not to exceed the limits of certain platforms. We are adding the formula : len( {{Copy}} )
Example - 2 :
On our social media planning app, we have a publish date field. We want to create a deadline for the designer to get the image ready 3 days before the publish date, so we will create a new field as a date for the design deadline. The formula we use : {{Publish Date}} - 3
Referencing fields:
In a Formula field, you can reference the fields on your list by using {{field_name}}.
If you want to calculate a 20% discounted price, the formula would look like this:
{{Price}} * 0.8
If you want to calculate the total price of an order:
{{Price}} * {{Quantity}}
You can combine multiple numeric operators by using parentheses:
( {{Price}} - {{Cost}} ) * 0.2
Logical Operators (Boolean type)
operator
description
example
and
returns true if the both boolean operands are true
3>2 and 2>1 returns true
{{Price}} > 1000 and {{Cost}} < 800
or
returns true if at least one of the boolean operands is true
3< 2 or 4<5 returns true
{{Price}} < 1000 or {{Cost}} >800
not
Returns true if the operand is not true
!IsBlank(“Text”)
equal
Returns true if the both sides of the equation are the same
{{Price}} = 1000
not equal
Returns true if the both sides of the equation are not the same
{{Price}} <> 1000
greater than
Returns true if the first numeric value is greater than the second numeric value
{{Price}} > 1000
less than
Returns true if the first numeric value is greater than the second numeric value
{{Price}} < 1000
greater than or equal
Returns true if the first numeric value is greater than or equal to the second numeric value
{{Price}} >= 1000
less than or equal
Returns true if the first numeric value is less than or equal to the second numeric value
