# Get the value of the row before

**URL:** <https://connect.superhuman.com/t/get-the-value-of-the-row-before/35246>\
**Category:** Ask the Community\
**Created:** [November 10, 2022, 9:04pm UTC](https://connect.superhuman.com/t/get-the-value-of-the-row-before/35246 "2022-11-10T21:04:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joelle\_Gaillard](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joelle_gaillard/32/24869_2.png) [@Joelle\_Gaillard](https://connect.superhuman.com/u/Joelle_Gaillard)\
**Post date:** [November 10, 2022, 9:04pm UTC](https://connect.superhuman.com/t/get-the-value-of-the-row-before/35246/1 "2022-11-10T21:04:35Z")

</div>

Hi,  
I’m trying to get the value of the cell in column x in the row above. How do I do it?

Thanks for the help

---

<div class="post-metadata">

**Author:** ![Quentin\_Morel](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/quentin_morel/32/31407_2.png) [@Quentin\_Morel](https://connect.superhuman.com/u/Quentin_Morel)\
**Post date:** [November 10, 2022, 9:13pm UTC](https://connect.superhuman.com/t/get-the-value-of-the-row-before/35246/2 "2022-11-10T21:13:02Z")

</div>

Hi @Joelle_Gaillard

Basically the formula will use the filter like this.

 ![image](https://global.discourse-cdn.com/coda1/original/3X/0/8/08216a5115f209d9f255749af818b6688e211fe3.png)

**But Please be careful**! Here I used RowId, but you will **not necessary have your row sorted by row id** like that. You must find the key your data are sorted in

I would suggest to select a criteria (alphabetical order, date), and create a **Rank according to this criteria** , and then use the same formula with this rank

For example if your data are sorted by date (with **no consideration** of row id)  
Create a rank by date like this

 ![image](https://global.discourse-cdn.com/coda1/original/3X/4/4/4445020eb38f261faf74166d1a45162e341b2268.png)

And use the same formula but this time with the filteria criter “rank by date” and not rowid !

 ![image](https://global.discourse-cdn.com/coda1/original/3X/e/6/e6a1e387a0b40cb1246d2536e2bd27f9879751dd.png)

And you can make this with every sorting criteria you want, to fit what you call “row from above”

Is that clear for you ?  
Cheers

Quentin

---

<div class="post-metadata">

**Author:** ![Joelle\_Gaillard](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joelle_gaillard/32/24869_2.png) [@Joelle\_Gaillard](https://connect.superhuman.com/u/Joelle_Gaillard)\
**Post date:** [November 10, 2022, 9:29pm UTC](https://connect.superhuman.com/t/get-the-value-of-the-row-before/35246/3 "2022-11-10T21:29:46Z")

</div>

Yes, perfectly clear.  
Thank you very much for the answer and its speed !

---

<div class="post-metadata">

**Author:** ![Quentin\_Morel](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/quentin_morel/32/31407_2.png) [@Quentin\_Morel](https://connect.superhuman.com/u/Quentin_Morel)\
**Post date:** [November 10, 2022, 9:32pm UTC](https://connect.superhuman.com/t/get-the-value-of-the-row-before/35246/4 "2022-11-10T21:32:18Z")

</div>

> [@Joelle\_Gaillard](#):
>
> Thank you very much for the answer and its speed !

No Problem Joelle, please let me know if you have any additonnal questions !

Q.

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [November 13, 2022, 9:32pm UTC](https://connect.superhuman.com/t/get-the-value-of-the-row-before/35246/5 "2022-11-13T21:32:54Z")

</div>

Closed on November 13, 2022, 9:32pm UTC

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.