Is it possible to track weight in pounds and ...

(Kristen Davis) #1

Is it possible to track weight in pounds and oz?

Ideally, I would like to use a formula to track the difference between two weights. (i.e. The difference between 8 lbs 2.6 oz and 8 lbs 4.1 oz. is 1.5 oz).

If pounds and oz are not possible, is it possible I use a formula to convert to/from grams so I can also use the weight data in a chart/graph ux?

(Mary Jane Pender) #2

A possible way to do this is to have 3 columns:

lbs1, oz1, converted1.

Converted1 would calculate the value of lbs.X16

and add the value in oz1 for the first weight.

So the converted field would have total equivalent in ounces. Another column for converted2 would do the same for the second weight lbs2, oz2.

Subtract converted 1 from converted 2 to get the difference and chart the difference column.

(Mary Jane Pender) #3

These additional columns should probably be virtual columns and then you can pick up the results and put it into a set of lbs &

ozs. for the difference.

(Kristen Davis) #4

Thank you, @Mary_Jane_Pender for the suggestion.

(Stephen Mattison) #5

If you aren’t in a hurry for instant results in app, Google Sheets has lots of conversion formulas that could likely do everything you want in the back end

DB, you’d just have to wait for the Sync. From Google CONVERT Site: CONVERT Converts a numeric value to a different unit of measure.

Sample Usage CONVERT(5.1, “g”, “kg”)

CONVERT(32, “C”, “F”)

CONVERT(35.7, “in^2”, “m^2”)

CONVERT(A1, A2, A3)

Syntax CONVERT(value, start_unit, end_unit)

value - the numeric value in start_unit to convert to end_unit

start_unit - The starting unit, the unit currently assigned to value .

end_unit - The unit of measure into which to convert value.

Notes The following list outlines the available unit conversions by category:

Weight - u, grain, g, ozm, lbm, stone, sg, cwt, uk_cwt, ton, uk_ton

Distance - ang, Picapt, pica, in, ft, yd, m, ell, mi, survey_mi Nmi, ly, parsec

Time - sec, min, hr, day, yr

Pressure - Pa, mmHg, Torr, psi, atm

Force - dyn, pond, N, lbf

Energy - eV, e, J, flb, c, cal, BTU, Wh, HPh

Power - W, PS, HP

Magnetism - ga, T

Temperature - C, F, K, Rank, Reau

Volume - ang^3, Picapt^3, tsp, tspm, tbs, in^3, oz, cup, pt, uk_pt, qt, l, uk_qt, gal, uk_gal, ft^3, bushel, barrel, yd^3, m^3, MTON, GRT, mi^3, Nmi^3, ly^3

Area - ang^2, Picapt^2, in^2, ft^2, yd^2, m^2,ar, Morgen,uk_acre, us_acre, ha, mi^2, Nmi^2, ly^2

Information - bit, byte

Speed - m/hr, mph, kn, admkn, m/s

The use of CONVERT between two different categories of start_unit and end_unit will result in an error. For example, CONVERT(13.2,“ft”,“C”) would result in an error as a result of an attempted conversion from distance units to temperature units.

See Also DATE: Converts a year, month, and day into a date.

DATEVALUE: Converts a provided date string in a known format to a date value.

TIME: Converts an hour, minute, and second into a time.

TIMEVALUE: Returns the fraction of a 24-hour day the time represents.

Examples The following example shows CONVERT between different sample start_unit and end_unit arguments.

CONVERT - Docs editors Help support.google.com