Formula Field References
Quire built-in fields for tasks
| Field name | Field type | Description | Example | Notes |
|---|---|---|---|---|
| me | Member | The current user | me in assignees |
|
| low | Priority arrow | The low priority arrow | subtasks.priority > low |
|
| medium | Priority arrow | The medium priority arrow | subtasks.priority > medium |
|
| high | Priority arrow | The high priority arrow | subtasks.priority > high |
|
| urgent | Priority arrow | The urgent priority arrow | subtasks.priority > urgent |
|
| priority | Priority arrow | The colored priority arrow of the task | subtasks.priority |
Specify more information for priority. |
| id | Number | The unique id number of the task | subtasks.id |
|
| name | Text | The name of the task | subtasks.name |
|
| description | Text | The description of the task | subtask.description |
|
| status | Status icon | The icon of the task’s status | subtasks.status |
Specify more information for status. |
| previousStatus | Status icon | The icon of the previous task’s status | subtasks.previousStatus |
Specify more information for previousStatus. |
| start | Date and Time | The start date and time of the task | subtasks.start |
|
| due | Date and Time | The due date and time of the task | parent.due |
|
| duration | Duration | The total duration of the due date subtract by the start date | subtasks.duration |
|
| peekaboo | Checkbox | If the task is peekaboo-ed or not | subtasks.peekaboo |
|
| archivedAt | Date and time | The date and time of when the task was peekaboo-ed | parent.archivedAt |
|
| archivedBy | Member | The member who has peekaboo-ed the task | parent.archivedBy |
|
| reshowAt | Date and time | The date and time of when the task will reshow | parent.reshowAt |
|
| assignees | Member | The assignee of the task | COUNT(subtasks.assignees) |
The external teams assigned to the task will not be included. |
| assignors | Member | The member who assign the task | subtasks.assignors |
Specify more information for assignors. |
| externalTeam | External Team | The external team assigned to the task | externalTeam.name |
If the External Team is assigned to a parent task, the External Team will appear in the same field for the subtasks. |
| tags | Tags | The tags added to the task | subtasks.tags |
Specify more information for tags. |
| level | Number | The number of the task level | MAX(descendants. level) |
|
| editedAt | Date and time | The date and time of when the task was edited | parent.editedAt |
|
| toggledAt | Date and time | The date and time of when the task’s status has been changed | parent.toggledAt |
|
| toggledBy | Member | The member who has modified the task’s status | toggledBy.name |
|
| createdAt | Date and time | The date and time of when the task was created | parent.createdAt |
|
| createdBy | Member | The member who has added the task | createdBy.name |
|
| completedAt | Date and time | The date and time of when the task was completed | parent.completedAt |
|
| completedBy | Member | The member who has completed the task | parent.completedBy |
|
| timelogs | Number of time logs | The number of time entries added to the task | timelogs.duration |
Specify more information for time logs. |
| timeSpent | Time | The total time spent on the task | subtasks.timeSpent |
|
| billingTimelogs | Number of time logs | The number of billable time entries added to the task | billingTimelogs.duration |
Specify more information for time logs. |
| billingTimeSpent | Time | The total billable time spent on the task | subtasks.billingTimeSpent |
|
| estimated | Time | The estimated time of the task | SUM(subtasks.estimated) |
|
| favorites | Member | The member who favorited the task | favorites.name |
|
| attachments | Number of attachments | The number of attachments added to the task | attachments.name |
Specify more information for attachments. |
| comments | Number of comments | The number of comments added to the task | comments.attachments |
Specify more information for comments. |
| subtasks | List of tasks | List of all the first level subtasks of the task | subtasks[0].{Cost} |
|
| activeSubtasks | List of tasks | List of all the first level active subtasks of the task | SUM(activeSubtasks.{Cost}) |
|
| completedSubtasks | List of tasks | List of all the first level completed subtasks of the task | SUM(completedSubtasks.{Cost}) |
|
| descendants | List of tasks | List of all the subtasks at every level of the task | SUM(descendants.{Cost}) |
|
| activeDescendants | List of tasks | List of all the active subtasks at every level of the task | SUM(activeDescendants.{Cost}) |
|
| completedDescendants | List of tasks | List of all the completed subtasks at every level of the task | SUM(completedDescendants.{Cost}) |
|
| parent | Task | The directly related parent task | parent.due |
|
| ancestors | List of tasks | List all of every parent tasks of the task | ancestors.due |
|
| project | Project | The project that the task belongs to | project.name |
Specify more information for project. |
| organization | Organization | The organization that the task belongs to | organization.name |
Specify more information for organizations. |
Add specified information after a field type
You can use the dot operator . to specify what you would like to call out for a specific field.
For example, if you only type priority in the Formula field, it will show the priority icon as the result. However, if you type priority.value , it will call out the value of the priority, which means that if you assigned the task as Urgent, it will show 2 as the formula result instead of the priority arrow.
Fields for projects
| Field name | Field type | Description | Example |
|---|---|---|---|
| id | Text | The project id | project.id |
| name | Text | The name of the project | project.name |
| start | Date | The start date of the project | project.start |
| due | Date | The due date of the project | project.due |
| color | Color code | The color of the project | project.color |
| roots | List of tasks | List of all the first level tasks (root tasks) in the project | project.roots |
| activeRoots | List of tasks | List of all the active first level tasks (root tasks) in the project | project.activeRoots |
| completedRoots | List of tasks | List of all the completed first level tasks (root tasks) in the project | project.completedRoots |
| tasks | List of tasks | List of all the tasks in the project | project.tasks |
| activeTasks | List of tasks | List of all the active tasks in the project | project.activeTasks |
| completedTasks | List of tasks | List of all the completed tasks in the project | project.completedTasks |
| organization | Organization | The organization the project belongs to | project.organization |
Fields for organizations
| Field name | Field type | Description | Example |
|---|---|---|---|
| id | Text | The organization id | organization.id |
| name | Text | The name of the organization | organization.name |
| color | Color code | The color of the organization | organization.color |
Fields for sublists
| Field name | Field type | Description | Example |
|---|---|---|---|
| id | Text | The sublist id | sublists.id |
| name | Text | The name of the sublist | sublists.name |
| start | Date | The start date of the sublist | sublists.start |
| due | Date | The due date of the sublist | sublists.due |
| color | Color code | The color of the sublist | sublists.color |
Note: To reference a specific sublist, you must include either the sublist name or its unique ID enclosed within square brackets [ ] after the sublist field reference. For example, sublists['Design'].due will retrieve the due date for the sublist named “Design.”
Fields for members (assignees, assignors)
| Field name | Field type | Description | Example |
|---|---|---|---|
| id | Text | The username id of the member | assignees.id |
| name | Text | The name of the member | assignees.name |
| Text | The email of the member | assignees.email |
|
| color | Color code | The color of the member | assignees.color |
Fields for attachments
| Field name | Field type | Description | Example |
|---|---|---|---|
| name | Text | The name of the attachments | attachments.name |
| url | Text | The URL of the attachments | attachments.url |
| size | Number | The size of the attachments | attachments.size |
| createdAt | Date and time | The date and time of when the attachments were added | attachments.createdAt |
| createdBy | Member | The member who added the attachments | attachments.createdBy |
Fields for comments
| Field name | Field type | Description | Example |
|---|---|---|---|
| description | Text | All the comments added to the task | comments.description |
| attachments | Number of attachments | The number of the attachments added to the comments | comments.attachments |
| createdAt | Date and time | The date and time of when the comments were added | comments.createdAt |
| createdBy | Member | The member who added the comments | comments.createdBy |
Fields for external teams and tags
| Field name | Field type | Description | Example |
|---|---|---|---|
| name | Text | The name of the External Team or the tags | externalTeam.name or tags.name |
| color | Color code | The color of the External Team | externalTeam.color or tags.color |
Fields for time logs
| Field name | Field type | Description | Example |
|---|---|---|---|
| user | Member | The member who added time entries to the task | timelogs.user |
| start | Date | The start date of when the time logs were added | timelogs.start |
| end | Date | The end date of when the time logs were added | timelogs.end |
| duration | Duration | The duration of the time logs added to the task | timelogs.duration |
| billable | Checkbox | True/ false value of whether the time logs are billable | timelogs.billable |
| note | Text | The notes of the time logs of the task | timelogs.note |
Fields for priority, statuses
| Field name | Field type | Description | Example |
|---|---|---|---|
| name | Text | The name of the priority or the status | priority.name or status.name |
| value | Number | The value of the priority or the status | priority.value or status.value |
| color | Color code | The color of the priority or the status | priority.color or status.color |
Fields for currency
| Field name | Field type | Description | Example |
|---|---|---|---|
| currency | Text | The currency symbol of the currency field | Cost.currency |
| value | Number | The currency value of the currency field | Cost.value |
Note: In the above example, Cost is a custom field and the field type was set as currency.
Fields for selections
| Field name | Field type | Description | Example |
|---|---|---|---|
| name | Text | The name of the selected options | Categories.name |
| color | Color code | The color of the selected options | Categories.color |
Note: In the above example, Categories is a custom field and the field type was set as selection.
Please contact us if you need more assistance.