Get last, non empty, value from Data Editor?

[Jonathon_Kohn]

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!

[ThinhDinh]

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.