--- title: "Formula Cards - monday.com" canonical: "https://support.appfire.com/space/RDD/199755988/Formula%20Cards%20-%20monday.com" format: markdown --- > Macro (aura-html) > Macro (excerpt) > > ![Dashboard Hub Formula Cards monday.com gadget thumbnail](media://46e8f841-8c6e-4b88-95c9-b9d36ebc52eb) > > [FORMULA CARDS - MONDAY.COM ](https://appfire.atlassian.net/wiki/spaces/RDD/pages/199755988) > > [Perform math calculations on column values from any board from any workspace. Display the result in Icon Cards (numerical results) or Donut Cards (percentage results)](https://appfire.atlassian.net/wiki/spaces/RDD/pages/199755988) ## Overview [monday.com](http://Monday.com) cannot perform calculations on column values. While you can create columns to track data such as the hourly price of your services, the budget for a marketing campaign, or the hours worked on a project,** you cannot use the platform to calculate the total charge for the hours billed on a project**. Don't worry, we have a solution to your problem. This gadget allows you to perform math calculations on column values **from any board from any workspace**. Display the result in Icon Cards (numerical results) or Donut Cards (percentage results). > ℹ️ Note that the maximum number of issues that the monday.com Formula Card gadget allows is fixed to 2500. ![Dashboard Hub formula cards monday](media://7de0f23b-29ef-4c47-a376-6c6cedf5c986) ## Create variables Variables store values that can be referenced later in the formula. They are useful to separate data in meaningful sets, so you can refer to it easily later in the formula or as the maximum value for the Donut Card visualization in %. You can create up to 5 variables, and **query any column from any board in any workspace**. In addition, you can filter the items by selecting multiple values of those columns, then, aggregate the result with different functions in your fields. ![Dashboard Hub formula cards monday variables](media://cf3dfe9a-c0ef-4ea5-890b-142d272138b2) ### Aggregations Aggregations are also common in the SQL domain. These functions get the values of grouped items as the input of that function to return a calculated value. This gadget currently supports seven functions: - **Count**. It counts the number of items in that column. - **Count (distinct)**. It counts the number of only distinct (different) items in the column. - **Sum**. It returns the addition of the sequence of the numbers of the column. - **Min**. It returns the smallest value of the range of values of the column. - **Max**. It returns the largest value of the range of values of the column. - **Mean**. The arithmetic mean, sums the values of the grouped items and divides the result by how many items are being averaged. - **Median**. It returns "the middle" value of the range of values of the column. If the number of values is even, then, the mean of the two values in the middle is returned. ## Create cards Cards display the result of a formula expression in a nice-looking way. This mathematical formula **accepts any of the previously created variables, but also integers and float numbers** e.g., -5, 100, 23.32, or -1,000,000.2, etc. To construct the relationship of these elements, formulas accept **mathematical operators** like **+** (plus), **-** (minus), ***** (multiplication), **/** (division), and **( )** (parenthesis). ![Dashboard Hub formula expression](media://e209c062-4014-4fbc-b8e2-5bc5fc693fad) To present the result, you can choose between two views: - **Icon Cards**: An icon displays any result of the formula. - **Donut Cards**: Percentages represent the result in a donut chart. ![Dashboard Hub formula card types](media://c88b5676-780b-4173-b0f6-19a82322aa88) ### View type: Icon Card The Icon Card requires: - A **label** (*mandatory*) to provide a meaningful description of the resulting number. - A **prefix** and/or **suffix** (*optional*) to add units or extra information to the number. - An **icon** (*mandatory*) to give a visual clue of the provided number. ![Dashboard Hub formula icon card](media://b663d550-fe82-4752-9aed-e44141471557) ### View type: Donut Card The Donut Card requires: - A **label** (*mandatory*) to provide a meaningful description of the resulting percentage. - A **prefix** and/or **suffix** (*optional*) to add units or extra information to the number. - A **max value** (*mandatory*) to indicate the maximum value of the percentage and paint the donut chart accordingly. If the max value is 100 and the result of the formula is 50, then, half of the donut is painted in the selected color. - A **color** (*mandatory*) to paint the donut chart. ![Dashboard Hub Formula Cards monday.com chart preview](media://b5a769e0-4541-4b7f-8c21-2a7dd4683dcf) ## Configuration Give your gadget a meaningful name so that it is clear what it does and when to use it. Fill out the rest of the fields as applicable, namely: - The **data source**, indicates the [http://monday.com](http://monday.com) account where you want to fetch the data from. The** variables** for**:** - The **workspace**, the **board, **and** **the** column** where the items are located. Any workspace, board, and column can be selected. - The **filter** for the board items. You can filter the items in the column using the filtering mechanism. ![Dashboard Hub Formula Cards monday.com filter configuration](media://f8338816-757f-4fb3-977b-29642aa0a94c) - The **Aggregations** to perform calculations -Count, Count (distinct), Sum, Min, Max, Mean, Median- over the results. - **View Types ** - **Icon Cards**: An icon displays any result of the formula. - **Donut Cards**: Percentages represent the result in a donut chart. The **formula expression** accepts the previously created variables, integers, and float numbers e.g., a, b, -5, 100, 23.32, or -1,000,000.2, etc. And mathematical operators like **+** (plus), **-** (minus), ***** (multiplication), **/** (division), and **( )** (parenthesis). - Indicate if you want to use the current settings for all the compatible gadgets in the dashboard. This option allows you to use the same default configuration for the remaining gadgets. ## Integrations - :monday.com:
monday > Macro (contentbylabel)
We are working on our growing catalog of [https://appfire.atlassian.net/wiki/spaces/RDD/pages/146310010](https://appfire.atlassian.net/wiki/spaces/RDD/pages/146310010), but drop us a line in case you want us to expedite a specific one, visit our [https://appfire.atlassian.net/wiki/spaces/RDD/pages/146309984](https://appfire.atlassian.net/wiki/spaces/RDD/pages/146309984). ## Dashboards This gadget is not included in any pre-defined dashboard.