# Get last, non empty, value from Data Editor?

**URL:** https://community.glideapps.com/t/get-last-non-empty-value-from-data-editor/18170
**Category:** Ask for Help
**Created:** [November 9, 2020, 5:50pm UTC](https://community.glideapps.com/t/get-last-non-empty-value-from-data-editor/18170 "2020-11-09T17:50:11Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Jonathon\_Kohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathon_kohn/32/8593_2.png) [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)
#### Post date: [November 9, 2020, 5:50pm UTC](https://community.glideapps.com/t/get-last-non-empty-value-from-data-editor/18170/1 "2020-11-09T17:50:12Z")

</div>

I’m using the data editor and a relation from one sheet to another to look for the last, non blank, item appearing in a column but I can’t find a way to bypass the blank entries and only pull the last actual data entry… halp!

Adding a checkbox to the single value columns would be GREAT!

![Screen Shot 2020-11-09 at 12.33.23 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/9079d6dcf337a3e735c346d29792605e7facb2d6.png)

---

<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: [November 9, 2020, 11:20pm UTC](https://community.glideapps.com/t/get-last-non-empty-value-from-data-editor/18170/2 "2020-11-09T23:20:33Z")

</div>

Good use case. I assume a long workaround for this can involve if then else and another relation to pull the last non-empty value back.