# Price list

**URL:** <https://community.glideapps.com/t/price-list/17453>\
**Category:** Ask for Help\
**Created:** [October 22, 2020, 3:25pm UTC](https://community.glideapps.com/t/price-list/17453 "2020-10-22T15:25:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Calle\_Ehrnberg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/calle_ehrnberg/32/15536_2.png) [@Calle\_Ehrnberg](https://community.glideapps.com/u/Calle_Ehrnberg)\
**Post date:** [October 22, 2020, 3:25pm UTC](https://community.glideapps.com/t/price-list/17453/1 "2020-10-22T15:25:46Z")

</div>

Hi! How do I create a price list where I want the most expensive item on top and the cheapest item in the bottom? I also want the items to be labeled with a number based on which order they are in the list. So the second most expensive item should be labeled with “2”. Also, the prices can be updated by me and when that happens I want the list to automatically change order and the items should get the correct label depending on where in the list they ended up.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 22, 2020, 3:53pm UTC](https://community.glideapps.com/t/price-list/17453/2 "2020-10-22T15:53:32Z")

</div>

> [@Calle\_Ehrnberg](#):
>
> How do I create a price list where I want the most expensive item on top and the cheapest item in the bottom?

You can use the sort option on your price column.

> [@Calle\_Ehrnberg](#):
>
> I also want the items to be labeled with a number based on which order they are in the list. So the second most expensive item should be labeled with “2”

You can use a RANK function inside the sheet to do this for you. It will update automatically.

---

<div class="post-metadata">

**Author:** ![Calle\_Ehrnberg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/calle_ehrnberg/32/15536_2.png) [@Calle\_Ehrnberg](https://community.glideapps.com/u/Calle_Ehrnberg)\
**Post date:** [October 22, 2020, 6:37pm UTC](https://community.glideapps.com/t/price-list/17453/3 "2020-10-22T18:37:36Z")

</div>

Thank you very much for the help!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 22, 2020, 10:06pm UTC](https://community.glideapps.com/t/price-list/17453/4 "2020-10-22T22:06:12Z")

</div>

If you have any problems implementing it, do let me know.