I am trying to use the filter formula to filter down a look up field value to the first value in the look up field. The look field returns an array of values and I want the formula to filter to the first one. I tried everything with AI, but nothing works. Keep getting errors. Basically, again, I have a linked field in a table. I then do a lookup field for that lined field which returns an array of items. I then want to filter this down to the first item in the list returned. Thanks.
Hi @ddsgad,
Have you tried the min function?
Would you mind sharing more details about your table’s structure if it doesn’t work? For example:
Table Project.
- primary: text
- name: text
- tasks: link to table
Table Task:
- primary: text
- project: link to table
- project name: formula (min(lookup(“Project”, “name”)))