Forum Discussion
Solved
Creating a customized column to show the four predecessor task types
I would like to insert a column that shows which of the four (4) possible predecessor task types (FS, SS, FF, SF) all the tasks have. Can anyone tell me if this is even possible, and if so, how can ...
- Jonathan,
Okay, then this formula should do it. Note, after posting my first response I realized it was not the Mid function but the Instr function that is needed.
Text1=IIf([Predecessors]<>"",Switch(instr(1,[Predecessors],"S")=0 And instr(1,[Predecessors],"F")=0,"FS",InStr(1,[Predecessors],"SS")>0,"SS",instr(1,[Predecessors],"FF")>0,"FF",instr(1,[Predecessors],"SF")>0,"SF",instr(1,[Predecessors],"FS")>0,"FS"),"")
John
Hi John
Yup - confirming only a single predecessor for each task.
Thanks
Jonathan
Yup - confirming only a single predecessor for each task.
Thanks
Jonathan
Jonathan,
Okay, then this formula should do it. Note, after posting my first response I realized it was not the Mid function but the Instr function that is needed.
Text1=IIf([Predecessors]<>"",Switch(instr(1,[Predecessors],"S")=0 And instr(1,[Predecessors],"F")=0,"FS",InStr(1,[Predecessors],"SS")>0,"SS",instr(1,[Predecessors],"FF")>0,"FF",instr(1,[Predecessors],"SF")>0,"SF",instr(1,[Predecessors],"FS")>0,"FS"),"")
John
Okay, then this formula should do it. Note, after posting my first response I realized it was not the Mid function but the Instr function that is needed.
Text1=IIf([Predecessors]<>"",Switch(instr(1,[Predecessors],"S")=0 And instr(1,[Predecessors],"F")=0,"FS",InStr(1,[Predecessors],"SS")>0,"SS",instr(1,[Predecessors],"FF")>0,"FF",instr(1,[Predecessors],"SF")>0,"SF",instr(1,[Predecessors],"FS")>0,"FS"),"")
John