Reference another column given an id

[LuizGuerra]

I have a field that gets the id from a different line, for example:

id	depends on id (void if doesnt)	status	can be done
1		In Progress	yes
2	1	To Do	no

In this table, each task have an ID.

This task might be done only after another task is done.

For that, I want to

if there is a value in "depends on id" and the status of that task is Done

show "yes"

otherwise show "no"

As a workaround in the meantime I used a Link to a Table and a Lookup, but I don't want extra columns to avoid clutter if possible.

How can I accomplish this?

More specifically, how do I reference another column given an id?

Thank you for your help!