Embed Formulas in Quire Permalink

Embedding formulas is only available in the Professional, Premium, Enterprise plans. More information can be found on our pricing page.

What areas support embedded formulas?

You can embed formulas in nearly all rich-text areas in Quire, including:

• Organization descriptions
• Project descriptions
• Task descriptions
• Folder and Smart Folder descriptions
• User profile descriptions
• Task comments
• Documents

Embedding formulas allows you to turn static text into live, auto-updating reports powered by task data.

Embed a Formula

How do I insert a formula in a description, comment, or document?

1. Click into a description, comment, or document editor.
2. Type the slash command / to open the command menu.
3. Select Formula from the list.
4. Paste or type your formula into the formula dialog.

Tip: Typing keywords after / filters the command list. Use arrow keys to navigate quickly.

Embedded Formula Examples for Projects

How do I calculate the total cost of all tasks in a project?

Use an embedded formula in the project description to show a live total cost:

Current total project cost: [embed the formula here] 

Paste the following formula into the formula dialog:

SUM(tasks.Cost)

This formula automatically sums the Cost field across all tasks in the project.

Note: A numeric or currency custom field named Cost must exist in the project

Learn all the functions you can use in the Quire formulas.

How can I create a simple project health indicator?

You can display a visual health status using a conditional (?:) formula:

Project Health Indicator: [embed the formula here] 

Formula example:

count(tasks where any.priority >= high and any.due < <today>) > 20 ? "🔴 Dangerous" : "🟢 Safe"

This formula:

• Counts overdue high priority tasks
• Displays a warning (🔴 Dangerous) if the count exceeds 20
• Updates automatically as task data changes

How do I track the average effort of subtasks with a specific tag?

You can embed a formula in Table View or descriptions to track effort scores:

AVG((subtasks where 'S1' in any.Sprint).Effort)

This formula:

• Filters subtasks with the Sprint value “S1”
• Calculates the average of their Effort field

Before using this formula:

• Effort must be a number-type custom field
• Sprint must be a selection-type custom field

Learn all the functions you can use in the Quire formulas.

Embedded Formula Tips

How do I reference a specific task in a formula?

When working in organization descriptions, folder descriptions, or documents, use the task identifier format:

#{project_id/23}

This returns the task with ID 23 from the specified project.

Note: The referenced task must belong to the same organization or folder. Otherwise, the formula will return a null value.

How do I list all projects at a certain level?

To display all projects within an organization, folder, or user, embed:

projects

The formula automatically updates when projects are added or removed.

How do I specify a particular member or project in a formula?

You can reference members and projects directly using identifiers:

• Member: @username
• Project: #{project_id}

Example: display a member’s email address:

@john.email

Example: calculate total time spent across a project:

SUM(#{project_id}.tasks.timeSpent)