Using Formulas in the Journal

The Glasshouse Journal 2.0 has some great option of using formulas for a single entry.

Formula Basics functions

  • User can use formulas to Concatenate (CONCAT), add numbers (+), subtract numberrs (-), multiply number (*) and/or divide numbers (/)
  • If you want to concatenate cells/properties, to use formula in the following syntax: ‘= CONCAT(Column A; Column B; “custom string”; Column X)’
  • For arithmetic operations, +=*/ operators can be used, as well as ( ) to group some operations
  • In arithmetic operations, if one of the arguments is not a number, the formula should return: FORMULA ERROR: Property X is not a number

Using Glasshouse default parameters in formulas

There are 4 Default Glasshouse properties you can use in formulas:
  1. Short description
  2. BIM Objects count
  3. BIM Objects quantity
    BIM Objects quantity is treated as a number, if there is a value there. If it’s missing and it is used in an arithmetic operation with some other numbers, then you should see the `not a number` formula error
  4. Tenderlist Number
You simply use them by name, just as any other property

Multiline

If you wish to add a line shift in a CONCAT formula you can do this by using a “new line character” which is \n (backslash + n).
This has to be included in a text string, or at least quoted – example: “\n”.
This method will allow you to span the CONCAT result over several lines, and can be used to CONCAT single line text with multiline text.

Tagged:

Leave A Comment?