Skip to main content
Question

How to show Predecessor Status [Lookup field]

  • March 8, 2019
  • 0 replies
  • 171 views
AdamKrzyzanek
Forum|alt.badge.img+10
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 column:
Recored ID# 1338 with Predecessor 1337 would show that previous task was completed.


I was looking on forum solution but unfortunately failed (some similar conversation started but no solution)
I tried to set up Same Table to Table relationship but it does not give me what I want as predecessor field is not unique and I recieve Record ID# as Key field.


    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.
    Terms & ConditionsAccessibility statement