# Select Math Column Units from another column

**URL:** <https://community.glideapps.com/t/select-math-column-units-from-another-column/23067>\
**Category:** Feature Requests\
**Created:** [February 19, 2021, 2:10am UTC](https://community.glideapps.com/t/select-math-column-units-from-another-column/23067 "2021-02-19T02:10:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thong\_Nguyen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thong_nguyen/32/21951_2.png) [@Thong\_Nguyen](https://community.glideapps.com/u/Thong_Nguyen)\
**Post date:** [February 19, 2021, 2:10am UTC](https://community.glideapps.com/t/select-math-column-units-from-another-column/23067/1 "2021-02-19T02:10:29Z")

</div>

This is fine if the units are selected by column

 ![Untitled](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5a5bca183824a4e407aa301fd78bf401e727055c.png)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 19, 2021, 2:12am UTC](https://community.glideapps.com/t/select-math-column-units-from-another-column/23067/2 "2021-02-19T02:12:51Z")

</div>

Yes! I’ve asked for this too. Perfect in inventory apps where “unit” could be something dynamic like “box”, “package”, “tube”, “carton”, etc.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 10, 2021, 2:21am UTC](https://community.glideapps.com/t/select-math-column-units-from-another-column/23067/3 "2021-09-10T02:21:34Z")

</div>

Agree that this would be useful, but if it’s just for display purposes then it’s easy enough to get the same thing with a template column. ie. an if-then-else column to determine the unit (which you would need anyway even if this feature was available), then a template column to combine the value and the unit.

---

<div class="post-metadata">

**Author:** ![Messias\_Carvalho](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/messias_carvalho/32/4586_2.png) [@Messias\_Carvalho](https://community.glideapps.com/u/Messias_Carvalho)\
**Post date:** [September 10, 2021, 2:35am UTC](https://community.glideapps.com/t/select-math-column-units-from-another-column/23067/4 "2021-09-10T02:35:01Z")

</div>

Is a good solution, and i used… but is not clean and don’t pass the unit to number entry.

---

<div class="post-metadata">

**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\
**Post date:** [September 10, 2021, 7:10am UTC](https://community.glideapps.com/t/select-math-column-units-from-another-column/23067/5 "2021-09-10T07:10:48Z")

</div>

You can use the Experimental Code column and my function Format Number.

> **[glide-format-number](https://replit.com/@MaximKM/glide-format-number#index.html)**
>
> A HTML, CSS, JS repl by MaximKM

It allows adding prefix and postfix to numbers, and formating to the desired precision.

> **[Google Chrome.app - Test On Submit · Glide](https://www.loom.com/share/8660638f0dc94df3be83493dc9989c31)**