Does anyone know how to return the “Value” of a field that is found with “Find” and not the relative position?
I have a tasklist with dependencies (Successors and Predecessors). I have the list of successors and am trying to populate teh predecessors with a formula thisRow.[Task Name].find(thisRow=thisRow.[Successors linked])
…a new problem has just arisen also which I think might be to do with the initial problem in that when I copied and pasted teh formula here, it has put “thisRow” before each field but that is not how it is written in my Column. It has by default added the “thisRow” before each field.
The Predecessor is the Task whose Succcessor is the Task in the same Row.
ie: The Predecessor of a task is the task that has the current task as its Successor.
I’m just not understanding your screenshot or instructions. If you want to share this doc, I can jump in and take a look. You can post a link that I click, and then you’ll get an email where you must grant me access. That way it’s not open to anyone to whom you don’t specifically grant access. Your call.
I don’t mean this to sound impatient but I’m just wondering what is happening as I can see both of you in my doc and not sure what is happening. I’m new to this so getting my head around the sytem also.
I have updated my sample doc above to explain this but this is the modified formula you will need to get the Predecessors ( the need to use contains cause due to it being a multiselect list, a simple = no longer works)
I nested it, hasn’t worked. I’m trying the separate column now.
Look, I’ll play around with it from here, you’ve been more than helpful kthank you. I get the path I need to take now so I’ll just muck around with it and get it working.
Thanks to you also Ander…Go eat the ass out of that low flying horse mate!