I have a need to lookup a unique id in another schedule and pull task information from that schedule, basically Task name, Start and Finish dates, and Notes. I was looking for a way to use VLOOKUP type formula, like it works for MS Excel, but couldn’t find it. Anyone got an idea on how to solve this ? Appreciate an answer !
Torstein, this is a simplified solution but you could link to the task as an external task. External links have some caveats but does bring in the fields you want. Let me know if that is something you know of or considered, or if you know that won’t work.