Custom Fields

Formula

Formula fields allow you to make calculations on value data like numeric, date or time on a work automatically.

How to set a formula

To create a formula field:

1. Click the Add Fields button and select Formula field type.
2. Add a field name.
3. Select available fields or functions from the dropdown and enter operators(+, -, * or /) to write any valid formula.
4. Click the Test button to check the validity of the syntax.
5. Choose the display form for the calculation result: Date, Date&Time, Numeric-integer, Numeric-Decimal, Percentages-value, Percentages- progress bar.
6. Add a description to the formula(not required)

Supported Fields

• Today (variable)
• Now (variable)
• Created Time
• Updated Time
• Estimated Point
• Dud Time
• Start Time
• Custom Number Fields
• Custom Date/Time Fields

Sample Formulas

• Remaining Days
• Formula: {Due Time} - {Now} + 1Day
• Display Form: Date
• Subtask completion progress
• Formula: SUM(Subtask - Estimated Point; Status = "completed") / SUM(Subtask - Estimated Point;)
• Display Form: Percentages - Progress bar

Text

A single line of plain text.

Long Text

A paragraph of plain text.

Rich Text

Text area with Markdown editing support.

Numeric - Integer & Decimal

A formatted numeric value, that can be used to make calculations on formula.

Date, Date&Time

A custom date, or time.

Dropdown - Single Choice & Multiple Choice

A series of options in a menu.

Checkbox

A true or false checkbox.

You can set an option as the default in a Dropdown or Checkbox.

Website

Any URL for quick access.

Progress bar

A progress bar that's manually set.

People

It can be single or multi-choice. The options range can be set to a member group.