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
BIM Objects count
BIM Objects quantityBIM 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
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.