Filter( ) formula based on lookup field?

Is there any way to base a filter formula on a lookup field? I have a very simple formula setting the value of text field:
Projects.filter(ID=ID).Project Description.

This works nicely and returns the description from the project table into the description field on my current table. I would like the ID field in the current table to be a lookup field based on the ID field in the Projects table, but this breaks the filter formula. The text in the ID field is concatenated from some other fields - not coming from a static table. I don’t seem to be able to find an elegant solution for this. Any ideas? Thank you!

Hi @Wendy_Levine

Would you mind share your doc or at least a few screenshot to help understanding ?


1 Like

Thank you - I decided to take another approach with this.