Help

Reference another column given an id

Topic Labels: Formulas
277 0
cancel
Showing results for 
Search instead for 
Did you mean: 
LuizGuerra
4 - Data Explorer
4 - Data Explorer
I have a field that gets the id from a different line, for example:
 
iddepends on id (void if doesnt)statuscan be done
1 In Progressyes
21To Dono
 
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!
0 Replies 0