This method of rounding is called "Round Down" Returns a number of the value rounded down to the nearest whole number. (Expression) This is a value to round up to the nearest whole number. This method of rounding is called "Round Up" Returns a number of the value rounded up to the nearest whole number. (Expression) This is a value to be rounded. This method of rounding is often called "Bankers Rounding". If X is exactly halfway between two whole numbers (X.5), the result is always the even number. Returns a number of the value rounded to the nearest whole number.
This is a numeric value to be raised to e. Returns e (the base of natural logarithms) raised to a power. Returns the square root of a number: the numeric value to find square root value of. Returns a number squared: the numeric value to be squared. Will return the Hypotenuse of a right angle. This example could be used to find the area of a circle. Will pick a random color each time you create a new item. It's good for Assemblies to have sum of that property in () on all sub parts. Gives you a sum of all sub item or children items under that parent item for example: will give you the sum of all sub-items under that item. Gives you the path of the PlanSwift.exe file. Gives you the path to the folder the item is located in. They are children's of sections, which do not have Units('Takeoff') specified. If the parent item is a Linear then the result would be FT.įor Labels must be. Gives you the parent item's Takeoff property Units, so you can specify the parent item !Units of ('PropertyName')Įxample will give you SQ FT if the parent item is an Area. works as well if you need the grandparent's same property name. Will get the parent's property with the same property name. Will give you the property of the parent of the parent item. Will get the parent item's property name.Įxample: will give you the parent item's property. Will create the current time when the item was created.
Will create the current date when the item was created. Go into Advanced Properties on a item you want the formula on. This will give you some examples of formulas that can be used.