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

In Quire, formulas are supported in markdown as well, which means that you can embed formulas in any description area for organizations, projects, user profiles, tasks, folders, smart folders and even comment areas for tasks. With this feature, you can generate an interactive report with formulas based on the data you have entered in your tasks.

To embed a formula in the description area or comment area, you will need to put the formula between double curly brackets {{ and }}.

Formula writing in markdown examples

Calculate total cost of all tasks for a certain project

If you want to calculate the total cost of all the tasks within a project, you can type in something like below in the project description area:

Current total project cost: {{ SUM(tasks.Cost) }}

Note: For the above example, you have to create a custom field named Cost first and set the format type to currency in your project.

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

Health checkup for a certain project

You can also set up a simple project health indicator in the Project Overview using the ?: operator. You can type something like this:

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

In the above formula, it will count the number of tasks that have a priority higher than or equal to high and the tasks that have a due date earlier than today. If the total number of tasks that fits the condition is more than 20, then it will display “🔴 Dangerous”, if not, it will show “🟢 Safe” instead.

Learn all the different operators you can use in the Quire formulas.

Formula in markdown writing tips

List out all the projects at certain level

If you want to list out all the projects that belong to an organization, folder or user, you can type something like below in its description area:

{{ projects }}

Avoid {{ }} being interpreted as formulas

If you want the double curly brackets {{ }} to be handled as text, you can type a backslash \ in front of it. You can type something like this:

\{{Emphasizing this part}} 

Specify a particular member/project in a formula

You can use the member identifier @member_usernameand the project identifier #{project_id} in your formula to call out a specific value.

For example, if you want to specify a certain member’s email address in the project’s description, you can type something like this:

{{ @john.email }}

Here’s another example, if you want to know how much time the entire project has spent, you can type something like this in the Organization Overview description:

{{ SUM(#{project_id}.tasks.timeSpent) }}