Formula field type 
Guidelines 
Text 
 Use if your formula results in text or contains literals with alphanumeric characters
 Enclose text literals in double quotes, e.g.,
SearchAndReplace(“Progressing” , “In progress”)

Numeric 
 Use to display results of mathematical calculations
 Numerical values only, positive or negative (integers, decimals)
 Type numbers directly into formula
e.g., Sum(12.5, 0.5) ), or

Reference a numerical field
e.g., Sum([Tax], [Total before tax]) )

Date 
 Use if your formula results in a date
 Dates do not have literal form in formulas

To reference a text field that holds a date: use
ToDate()
 e.g., a text field with the value Jan 30, 2021 should be referenced as
ToDate("Jan 30, 2021")
 To reference today's date: use
Today()

Date/ Time 
 Use if your formula results in date and time of day

Time of Day 
 Use if your formula results in time of day

Duration 
 Use if your formula results in a span of time

Create a duration: subtract two date fields or two date and time fields

Durations can be the result of functions, such as: Hours(2) or Days(1)

Durations can be positive or negative

Negative durations result from subtracting a later date value

Checkbox 

Phone Number 
Use if your formula results in a phone number

Email Address 
 Use if your formula results in an email address
 If your table has names and email domains in different fields, use this field type to link them together and display a mailto link
 When a user clicks the link, an email is generated

User 
Use if your formula results in a user value

Listuser 
Use if your formula results in a list of user values

URL 
 Use if your formula results in a URL
 Use a formula to combine values from fields to create URLs, e.g.,
If a field contains a website address and another field contains a specific page name on the website, create a formula to combine the fields. This creates a link in each record that leads to a different page on the website

Work Date 

Use if your formula results in a date and your app uses a predecessor field to track the timing of dependent tasks
 For partial days, use to measure dates in fractional amounts
Example:
 A task begins on a certain date in the Start Date field (date field type)
 Task takes 2.5 days to complete
 Task is tracked in the Duration field (work date field type)
 To calculate those values (including partial day), add the formula to a Finish Date field (formula work date field type)

Rich Text 

Use if your formula displays images, buttons, text, etc. e.g.,
To display text in a different font size and color:
<div style=\"color:Salmon;fontsize:28px\">"&[Task Name]&"</div>

Multiselect Text 
