Get last, non empty, value from Data Editor?

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

1 Like

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.