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!
