Version: 25.3
Available to Solibri Office users, powerful functions can now be used to enhance workflows in ITOs and Classifications.
Site users can view and run formula columns but not make edits.
Information takeoff columns are labelled with letters (A, B, C, etc.) to help identify columns when writing formulas.
A new column type, "Formula," has been added. You can manage the columns in the ITO table as usual, either by editing an existing column or adding a new one. In the column settings, you can select the "Formula" column type.
-
The formula field always starts with an equals sign (=), which cannot be removed or edited.
-
As you type, auto-suggestions appear, filtering available column names and suggesting supported functions.
-
When selecting a function, it is inserted with parentheses, and the cursor is placed inside the first parenthesis for easy input.
Important
-
When a new column is added it will be positioned to the left of an existing column.
-
This might shift the lettering of existing columns (e.g., what was previously "B" may become "C").
-
However, formulas automatically adjust and retain references to the correct columns.
-
This also applies when reordering columns—formulas remain intact despite changes in column positions
-
-
Solibri's internal unit of length is millimetres, regardless of user-defined settings. Any calculations made use length as millimetres, and this is important to consider while creating formulas and setting formats.
-
Column Formats (Volume and Area) will apply an automatic conversion to formula column results.
Table 8. Logic Functions
|
Function |
Description |
|---|---|
|
AND |
Returns TRUE if all arguments are true. Syntax: AND(value1; value2; ...) |
|
IF |
Returns one value if a condition is true, another if false. Syntax: IF(condition; value_if_true; value_if_false) |
|
IFERROR |
Returns a value if an expression results in an error. Syntax: IFERROR(value; value_if_error) |
|
NOT |
Returns the logical negation of an argument. Syntax: NOT(value) |
|
OR |
Returns TRUE if any argument is true. Syntax: OR(value1; value2; ...) |
Table 9. Math Functions
|
Function |
Description |
|---|---|
|
ABS |
Returns the absolute value of a number. Syntax: ABS(number) |
|
ACOS |
Returns the arccosine of a number. Syntax: ACOS(number) |
|
ASIN |
Returns the arcsine of a number. Syntax: ASIN(number) |
|
ATAN |
Returns the arctangent of a number. Syntax: ATAN(number) |
|
COS |
Returns the cosine of a number. Syntax: COS(number) |
|
DEGREES |
Converts radians to degrees. Syntax: DEGREES(angle) |
|
CEILING |
Rounds a number up to the nearest integer. Syntax: CEILING(number) |
|
FLOOR |
Rounds a number down to the nearest integer. Syntax: FLOOR(number) |
|
INT |
Returns the integer part of a number. Syntax: INT(number) |
|
MAX |
Returns the maximum value from a list. Syntax: MAX(number1; number2; ...) |
|
MIN |
Returns the minimum value from a list. Syntax: MIN(number1; number2; ...) |
|
MOD |
Returns the remainder of a division operation. Syntax: MOD(number; divisor) |
|
PI |
Returns the value of π (pi). Syntax: PI() |
|
POWER |
Raises a number to a specified power. Syntax: POWER(base; exponent) |
|
PRODUCT |
Returns the product of a list of numbers. Syntax: PRODUCT(number1; number2; ...) |
|
ROUND |
Rounds a number to a specified number of decimal places. Syntax: ROUND(number; num_digits) |
|
ROUNDDOWN |
Rounds a number down to a specified number of decimal places.Syntax: ROUNDDOWN(number; num_digits) |
|
ROUNDUP |
Rounds a number up to a specified number of decimal places. Syntax: ROUNDUP(number; num_digits) |
|
SIN |
Returns the sine of a number. Syntax: SIN(number) |
|
SQRT |
Returns the square root of a number. Syntax: SQRT(number) |
|
SUM |
Returns the sum of a list of numbers. Syntax: SUM(number1; number2; ...) |
Table 10. Text Functions
|
Function |
Description |
|---|---|
|
CONCAT |
Concatenates multiple strings into one. Syntax: CONCAT(text1; text2; ...) |
|
EXACT |
Checks if two strings are exactly the same. Syntax: EXACT(text1; text2) |
|
FIND |
Returns the position of a substring within a string. Syntax: FIND(substring; text; start_num) |
|
LEFT |
Returns the left part of a string. Syntax: LEFT(text; num_chars) |
|
LEN |
Returns the length of a string. Syntax: LEN(text) |
|
LOWER |
Converts a string to lowercase. Syntax: LOWER(text) |
|
MID |
Extracts a substring from the middle of a string. Syntax: MID(text; start_num; num_chars) |
|
PROPER |
Capitalizes the first letter of a string and converts the rest to lowercase. Syntax: PROPER(text |
|
RIGHT |
Returns the right part of a string. Syntax: RIGHT(text; num_chars) |
|
TRIM |
Removes leading and trailing spaces from a string. Syntax: TRIM(text) |
|
UPPER |
Converts a string to uppercase. Syntax: UPPER(text) |
|
VALUE |
Converts a string to a number. Syntax: VALUE(text) |
Table 11. Validation and Info Functions
|
Function |
Description |
|---|---|
|
ISBLANK |
Checks if a value is blank. Syntax: ISBLANK(value) |
|
ISLOGICAL |
Checks if a value is a logical value (TRUE or FALSE). Syntax: ISLOGICAL(value) |
|
ISNONTEXT |
Checks if a value is not text. Syntax: ISNONTEXT(value) |
|
ISNUMBER |
Checks if a value is a number. Syntax: ISNUMBER(value) |
|
CHOOSE |
Returns a value from a list based on an index number. Syntax: CHOOSE(index_num; value1; value2; ...) |
Table 12. Operators
|
Function |
Description |
|---|---|
|
+ |
Addition: Adds two values. Example: 5 + 3 → 8 |
|
& |
Concatenation: Joins two strings together. Example: "Hello" & " World" → **“Hello World”` |
|
/ |
Division: Divides one number by another. Example: 10 / 2 → 5 |
|
= |
Equality: Checks if two values are equal. Example: 5 = 5 → TRUE |
|
> |
Greater Than or Equal: Checks if one value is greater than or equal to another. Example: 3 > 5 → FALSE |
|
< |
Less Than: Checks if one value is less than another. Example: 2 < 10 → TRUE |
|
>= |
Greater Than or Equal: Checks if one value is greater than or equal to another. Example: 3 >= 5 → FALSE |
|
<= |
Less Than or Equal: Checks if one value is less than or equal to another. Example: 7 <= 7 → TRUE |
|
* |
Multiplication: Multiplies two values. Example: 4 * 3 → 12 |
|
!= |
Not Equal: Checks if two values are not equal. Example: 8 != 5 → TRUE |
|
^ |
Power: Raises a number to a power. Example: 2 ^ 3 → 8 |
|
- |
Subtraction: Subtracts one value from another. Example: 9 - 4 → 5 |