Custom Fields
Last updated
Last updated
Formula fields allow you to make calculations on value data like numeric, date or time on a work automatically.
To create a formula field:
Click the +Create button and select Formula field type.
Add a field name.
Select available fields or functions from the dropdown and enter operators(+, -, * or /) to write any valid formula.
Click the Check Syntax button to check the validity of the syntax.
Choose the display form for the calculation result: Date, Date&Time, Integer, Decimal, Percentages-value, Percentages- progress bar.
Add a description to the formula(not required)
Today (variable)
Now (variable)
Create Time
Updated Time
Estimated Points
Due Time
Start Time
Custom Number Fields
Custom Date/Time Fields
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
A single line of plain text.
A paragraph of plain text.
Text area with Markdown editing support.
A formatted numeric value, that can be used to make calculations on formula.
A custom date, or time.
A series of options in a menu.
A true or false checkbox.
You can set an option as the default in a Dropdown, Radio Button, Rich Text, Long Text, or Member.
Any URL for quick access.
A progress bar that's manually set.
It can be single or multi-choice. The options range can be set to a member group.
