The Unit Converter Pack converts values to and from a wide variety of different units of measure. It features the ability to convert length, volume, mass, pressure, time, and many other common values.
There are a few guiding principles in shaping your formulas to return meaningful results:
The formulas use the Abbreviation of the unit as a parameter for a formula. For example, pound will be “lb” and millimeter will be “mm.” The easiest way to invoke this is to create use the sync table as a lookup and reference the Abbreviation column. It is often also helpful to use a filter on the destination value to make sure you are converting between compatible measures. You access this by referencing the Measure column. The Pack calculations will return a numeric value. This allows you to concatenate your result with the unit of your choice or use it to feed another formula. You may find it helpful to use the Round() Coda formula to limit decimal places to make your results cleaner. Example 1: Use the Pack as a simple calculator:
Number to Convert:
From: To:
Result:
Example 2: Use the Convert button inside a table.
Example 3: It can also be helpful to know what units you are possible for conversion. You wouldn't want to try to convert yards to teaspoons for instance. The FindPossible() formula will return a list of those possibilities.
Example 4: Finally, the Units Available Sync Table loads a full list of all units available as well as some information about each unit to help you set up calculations. You can also use the ListUnits() Formula to find all units without using the sync table.