Filter record based on record id and linked field

[Artur_Mkrtchya1]

Hey folks,

I have a table called Tasks and it has linked record called Owning Team 

I want to filter it based on Team RecordID something like FIND("recZyPUXXXXX", {Owning Team} & '')

this does not work for RecordID although when getting the records via API Owning Team values are RecordIDs.

[TheTimeSavingCo]

Hm, I think if you're trying to do this you'll need to
1. Create a new formula field `Teams` with the formula `RECORD_ID()`
2. Create a lookup field in `Tasks` to display the value from the step 1
3. Use your filtering logic on on the value from step 2

[artu-hnrq]

2. Create a lookup field in `Tasks` to display the value from the step 1

---

I was scary of finding this answer here! 😥
But I got it! It's the best workaround.