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.
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.