--- title: "How to create the \"Formula\" property" description: "The formula property is suitable for any calculations based on other properties" url: https://help-takeoff.kreo.net/en/articles/6204588-how-to-create-the-formula-property collection: "Properties" updated: 2026-10-12 language: en alternates: [fr] --- # How to create the "Formula" property The formula property is suitable for any calculations based on other properties ## **Introduction** [**Properties**](https://help-takeoff.kreo.net/en/articles/6158685-what-is-a-property.md) are inputs for Items and Assemblies. This is the first step before creating an Item or an Assembly. After you apply properties in Item or Assembly, they'll be transformed into a column in the Items report. ## **How to create the "Formula" property** 1. Go to the [Assemblies Database](https://help-takeoff.kreo.net/en/articles/6158615-what-is-assemblies-database.md) page and open the [Properties](https://help-takeoff.kreo.net/en/articles/6158685-what-is-a-property.md) tab there ​ ![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715091157_4675.png) 2. Press the **New button ->** select the **Formula type** ​ ![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715091157_6192.png) 3. Set a name for your property _(the field is mandatory)_ ​ ![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715091157_9426.png) _The name must be unique_ 4. Specify the **Unit** ​ ![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715091157_9059.png) _Unit can be further changed when adding it to Item and to Assembly, and when applying it to Measurements_ ​ 5. Specify the **Group** _(the field is optional)_ To create a group, perform the following steps: 1. Press "**Group**" on the input field 2. Name the group 3. Press the **Create button** ​ ![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715091157_7913.png) _The group will be saved. Next time, you can simply select it_ _from the list_ ​ 6. There're **4 types of values** available for working with formulas: ​ ![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715091157_6139.png) ​ 1. **MEASURES** — data from your Takeoff (area, perimeter, length, etc.): `MeasuredCount` — a number of Count tool points. All other measurements (polygon, rectangle and polyline) have Count equal to 1 `MeasuredLength` — length of a polyline `MeasuredArea` — area of a polygon `MeasuredPerimeter` — perimeter of a polygon `MeasuredWidth` — width of a rectangle created using the tools _Rectangle 2, Rectangle 3_ `MeasuredHeight` — height of a rectangle created using the tools _Rectangle 2, Rectangle 3_ ​ 2. **FUNCTIONS** — check below the list of functions available: `ABS` — returns the absolute value of a number, which is the number without its sign `AND` — returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false `AVERAGE` — returns the numerical average value in a dataset, ignoring text `CHOOSE` — returns an element from a list of choices based on an index `CONCAT` — returns the concatenation of two values. Equivalent to the \`&\` operator `COS` — returns the cosine of an angle provided in radians `COT` — returns the cotangent of an angle provided in radians `COUNT` — returns the number of numeric values in a dataset `DEGREES` — converts an angle value in radians to degrees `FIND` — returns the position at which a string is first found within text, case-sensitive `IF` — returns one value if a logical expression is \`TRUE\` and another if it is \`FALSE\` `LEFT` — returns a substring from the beginning of a specified string `LEN` — returns the length of a string `MAX` — returns the maximum value in a numeric dataset `MEDIAN` **—** returns the median value in a numeric dataset `MID` — returns a segment of a string `MIN` — returns the minimum value in a numeric dataset `NOT` — returns the opposite of a logical value - \`NOT(TRUE)\` returns \`FALSE\`; \`NOT(FALSE)\` returns \`TRUE\` `OR` — returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false `PI` — returns the value of pi to 9 decimal places `POWER` — returns a number raised to a power `RADIANS` **—** converts an angle value in degrees to radians `RIGHT` — returns a substring from the end of a specified string `ROUND` — rounds a number to a certain number of decimal places according to standard rules `ROUNDDOWN` — rounds a number to a certain number of decimal places, always rounding down to the next valid increment `ROUNDUP` — rounds a number to a certain number of decimal places, always rounding up to the next valid increment `SIN` — returns the sine of an angle provided in radians `SQRT` — returns the positive square root of a positive number `SWITCH` — tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met `TAN` — returns the tangent of an angle provided in radians ​ 3. **PROPERTY** — list of all properties used in your database 📝 **Note!** Start typing in the text box to find what you need. You can also scroll up and down using the arrow keys. To insert the value you selected into the formula, click `Tab` or `Enter` ​ 4. **VALUES** — **numeric values eg 2.75.** **Note!** Numeric values will not be automatically converted when used in a formula. ​ 7. Insert **Formula** _(the field is optional)_ ​ ![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715091157_6310.gif) _Formula can be further changed when adding it to Item and to Assembly, and when applying it to Measurements or Folders_ 8. Hit the **Create button** to create a new property ​ ![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715091157_3357.png) 9. Once the Property has been created, it'll appear in the Properties tab inside the group you've specified when creating a property ​ ![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715091157_6231.png) ​ ## **How to edit a property?** 1. Click on the row as it's shown on the screenshot below: ​ ![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715091157_4090.png) 2. Make all the necessary edits & press **Save** ​ ![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715091157_8416.png) 3. To duplicate or delete your property, right click on it & select the relevant option ​ ![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715091157_6951.png) ## Related - [How to create the "Single Select" property](https://help-takeoff.kreo.net/en/articles/6206019-how-to-create-the-single-select-property.md) - [How to create the "Text" property](https://help-takeoff.kreo.net/en/articles/6205968-how-to-create-the-text-property.md) - [How to create the "Number" property](https://help-takeoff.kreo.net/en/articles/6202303-how-to-create-the-number-property.md) - [What is a Property?](https://help-takeoff.kreo.net/en/articles/6158685-what-is-a-property.md) - [Create & work with properties](https://help-takeoff.kreo.net/en/articles/6168904-create-and-work-with-properties.md)