=TASKLOOKUP
The TASKLOOKUP function queries any instance task in ProcessPlan and returns the requested attribute.
Syntax
Section titled “Syntax”=TASKLOOKUP(FieldTokenToRetrieve; TemplateTaskID; TaskQuery)-
FieldTokenToRetrieve**:** Any Field Token you want to retrieve from the task.
-
TemplateTaskID: The template ID of the process task.
-
TaskQuery: The search query you want to use. You can query using any task related attribute (completed date, assigned to name, etc.).
The easiest way to create a task query is by creating a filter on the all tasks table and then copying everything after the “filter=” parameter in the URL.