Dear community,
for the last week I'm trying to filter tasks that are in a specific project in Asana. The tasks have 4 custom fields options: Question, To do, In Progress, Verify and Done. I have made a table where I only want to show the tasks with the custom field "Question". I have checked the JSON file and the data I get back is correct. The tasks each have their correct custom fields value assigned. However when I SELECT the "Question" tasks I get tasks from random custom fields.
I have found one task in the data list called "In het footermenu en dan de 3e kolom staat in het engels "Desktop view". In de andere talen niet. Waarvoor is dit?". This task has the correct "Question" custom fields value. However when I SELECT the data, it appears under the column that only selects the tasks that are marked with the custom fields value "Done".
I think that it has to do something with the way I SELECT the values. This is my SELECT formula: SELECT(@/data/name;, AND(@/data/custom_fields[4]/enum_value/name;="Question",@/data/completed;="false"))
The custom_fields[4] is the custom fields that have the question, to do, in progress, verify and done options.
Does anyone know what I do wrong?
Thank you for your time and effort,
Dennis S.