How to show Predecessor Status [Lookup field]
How to show if predecessor is completed or status? I have table with structure as below, and I would like to pull data from predecessor to know if already completed. So in this case in additional ...
Forum Discussion
It appear that you only need to deal with a single predecessor per record.
Try creating a new field called Predeceesor mirror with a formula value of ToNumber(Predecessor])
Set up a relationship of the rec Reds with themself and use that field as the refr nice field on the right side of the relationship.
Then use a combined text summary field to float up the status
Concert that to text with a new formula field
ToText[My combined text Summary if the status field])
Let me know if that works as I�ve never actually tried doing that.
If that works, then there are variations to handle where you have multiple predecessors.
Try creating a new field called Predeceesor mirror with a formula value of ToNumber(Predecessor])
Set up a relationship of the rec Reds with themself and use that field as the refr nice field on the right side of the relationship.
Then use a combined text summary field to float up the status
Concert that to text with a new formula field
ToText[My combined text Summary if the status field])
Let me know if that works as I�ve never actually tried doing that.
If that works, then there are variations to handle where you have multiple predecessors.
- Thank you Champion:)
Actually, I just showed one but I need up to 6:)
But with the same logic I made 6 relationships, did "lookup" field and it works:)
Big thanks for help. - Thx for letting me know the approach is viable!
- @Manny Pinheiro,
Actually to show 6 predecessor statuses I created 6 relationship with same table.
------------------------------
Adam Krzyzanek
------------------------------- Adam,
I have a similar problem. I am trying to think through if there is a way to use Pipelines to solve this instead of creating more relationships. That way it can scale.
Here is my stream of consciousness:
A Predecessor goes to Complete,
The Pipeline looks for Successors
It checks how many other Predecessors are on that Task
If they are all Complete, the Pipeline marks a CB on the Successor
I am not sure if Pipelines can do this but I am going to poke around and see if I can make it work.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
